As a market research analyst, I require a feature that allows me to access the top N populated countries in a continent, where N is specified by me, to analyse regional market potential effectively.
SELECT Population, name as country, continent
FROM country
limit 5; -- retrieves Population, country name, continent and limits to 5 results
As a market research analyst, I require a feature that allows me to access the top N populated countries in a continent, where N is specified by me, to analyse regional market potential effectively.
SELECT Population, name as country, continent FROM country limit 5; -- retrieves Population, country name, continent and limits to 5 results