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
10. Task 6

Instruction

Great!

It's time to find states that have a total land area that's greater than the average of all states' total land area.

Note: Total land area is the difference between total area and water area.

Exercise

For states with a total land area that's greater than average, show the state's name and its total land area (name this column: land_area).

Stuck? Here's a hint!

Remember that total land area is the difference between the state's total area and its water area.

In the WHERE clause, use this comparison...

(s.total_area - s.water_area)

... with the subquery:

SELECT AVG(total_area-water_area) FROM state