Instruction
The states in the USA are quite different: some of them have more than 10 million people; others, less than 1 million. Find which states have a population of more than 10 million.
Exercise
For all states with a population greater than 10 million, show their names, population, and total area (in square kilometers). Sort the result by population, in descending order.
Stuck? Here's a hint!
In the WHERE clause, use the condition population > 10000000.
Use ORDER BY to sort the records in the result set.
Learn more in the Filtering rows and Ordering sections in our SQL Basics course.
