Find the government form name and total population for each government form whose average life expectancy is longer than 72.
CREATE TABLE country (GovernmentForm VARCHAR, Population INTEGER, LifeExpectancy INTEGER)
SELECT SUM(Population), GovernmentForm FROM country GROUP BY GovernmentForm HAVING AVG(LifeExpectancy) > 72
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE country (GovernmentForm VARCHAR, Population INTEGER, LifeExpectancy INTEGER) Question: Find the government form name and total population for each government form whose average life expectancy is longer than 72. [/INST] SELECT SUM(Population), GovernmentForm FROM country GROUP BY GovernmentForm HAVING AVG(LifeExpectancy) > 72 </s>