Schema: CREATE TABLE country (Continent VARCHAR, Population INTEGER, LifeExpectancy INTEGER)
Question: Find the average life expectancy and total population for each continent where the average life expectancy is shorter than 72?
SQL: SELECT SUM(Population), AVG(LifeExpectancy), Continent FROM country GROUP BY Continent HAVING AVG(LifeExpectancy) < 72