SELECT sum(Population) ,  avg(LifeExpectancy) ,  Continent FROM country GROUP BY Continent HAVING avg(LifeExpectancy)  <  72
Find the average life expectancy and total population for each continent where the average life expectancy is shorter than 72?
SELECT sum ( Population ) , avg ( LifeExpectancy ) , Continent FROM country GROUP BY Continent HAVING avg ( LifeExpectancy ) < 72
select sum ( population ) , avg ( lifeexpectancy ) , continent from country group by continent having avg ( lifeexpectancy ) < value
Find the average life expectancy and total population for each continent where the average life expectancy is shorter than 72 ?