CREATE TABLE country (GNP INTEGER, population INTEGER, GovernmentForm VARCHAR)
What is the average GNP and total population in all nations whose government is US territory?
SELECT AVG(GNP), SUM(population) FROM country WHERE GovernmentForm = "US Territory"