Task: Text to Code
Input (English): Find the average life expectancy and total population for each continent where the average life expectancy is shorter than 72?
Output (English): SELECT sum(Population) ,  avg(LifeExpectancy) ,  Continent FROM country GROUP BY Continent HAVING avg(LifeExpectancy)  <  72