How the name and the extension where the capital is an extension of name of the country.
Answers
Answered by
0
Answer:
WHERE c2.population = t.max_pop
The second LEFT JOIN allows to get the population of the country's capital
The third LEFT JOIN allows to get the population of the country's biggest city (t.max_pop).
And we keep only the cities where these two numbers are equal.
Similar questions