I am practicing MySQL JOINs and was hoping I could get some insight on how to do a particular problem.
I am using the World database, it has a table called City with name, population, country code. It also has a table called Country, with Code and Name.
What I am trying to do is, SELECT all the cities for a country IF AT LEAST ONE city in that country has a population of 5,000,000 or more. So far I've only been able to get the Cities that have a population of 5,000,000 or more.
So in other words, if one city in a country has 5,000,000 or more population, get all the cities for that country.
I hope this makes sense. Any guidance to tutorials or documentation on how to do these types of JOINs would be great.