What is the average GNP and total population in all nations whose government is US territory?
CREATE TABLE country (GNP INTEGER, population INTEGER, GovernmentForm VARCHAR)
SELECT AVG(GNP), SUM(population) FROM country WHERE GovernmentForm = "US Territory"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE country (GNP INTEGER, population INTEGER, GovernmentForm VARCHAR) Question: What is the average GNP and total population in all nations whose government is US territory? [/INST] SELECT AVG(GNP), SUM(population) FROM country WHERE GovernmentForm = "US Territory" </s>