Session Ready
Exercise

Subquery inside WHERE

The video exercise pointed out that subqueries inside WHERE can either be from the same table or a different table. In this exercise, you will nest a subquery from the populations table inside another query, also from the populations table. Your goal is to figure out which countries had high average life expectancies in 2015.

You can use SQL to do calculations for you. Suppose you only want records from 2015 with life_expectancy above 1.15 * avg_life_expectancy. You could use the following SQL query:

SELECT *
FROM populations
WHERE life_expectancy > 1.15 * avg_life_expectancy
  AND year = 2015;
Instructions 1/2
undefined XP
  • 1
  • 2
  • Begin by calculating the average life expectancy from the populations table.
  • Filter your data to return records from 2015 only.
Loading