What is the total population and average area of countries in the continent of North America whose area is bigger than 3000 ?
CREATE TABLE country (population INTEGER, surfacearea INTEGER, continent VARCHAR)
SELECT SUM(population), AVG(surfacearea) FROM country WHERE continent = "north america" AND surfacearea > 3000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE country (population INTEGER, surfacearea INTEGER, continent VARCHAR) Question: What is the total population and average area of countries in the continent of North America whose area is bigger than 3000 ? [/INST] SELECT SUM(population), AVG(surfacearea) FROM country WHERE continent = "north america" AND surfacearea > 3000 </s>