Database: world_1
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