Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Coding Challenge – July 2020

Introduction
Tasks
5. Task 1

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.