Problem

Write a SQL query that returns the top 3 most populous countries.
Example input:
N/A
Example output:
China, India, United States

Solution

SELECT name, population
FROM world
ORDER BY population DESC
LIMIT 3;

/*

The solution is optimal because it uses the ORDER BY and LIMIT clauses to sort the table by population in descending order and then limit the results to the top 3.

*/