CREATE TABLE city (
    ID NUMBER PRIMARY KEY,
    Name TEXT,
    CountryCode TEXT,
    District TEXT,
    Population NUMBER,
    FOREIGN KEY ("CountryCode") REFERENCES country("Code")
);
CREATE TABLE sqlite_sequence (
    name TEXT,
    seq TEXT
);
CREATE TABLE country (
    Code TEXT PRIMARY KEY,
    Name TEXT,
    Continent TEXT,
    Region TEXT,
    SurfaceArea NUMBER,
    IndepYear NUMBER,
    Population NUMBER,
    LifeExpectancy NUMBER,
    GNP NUMBER,
    GNPOld NUMBER,
    LocalName TEXT,
    GovernmentForm TEXT,
    HeadOfState TEXT,
    Capital NUMBER,
    Code2 TEXT
);
CREATE TABLE countrylanguage (
    CountryCode TEXT PRIMARY KEY,
    Language TEXT,
    IsOfficial TEXT,
    Percentage NUMBER,
    FOREIGN KEY ("CountryCode") REFERENCES country("Code")
);

Question: What are the names of all the countries that became independent after 1950?
SQL: SELECT Name FROM country WHERE IndepYear  >  1950

Question: Give the names of the nations that were founded after 1950.
SQL: SELECT Name FROM country WHERE IndepYear  >  1950

Question: How many countries have a republic as their form of government?
SQL: SELECT count(*) FROM country WHERE GovernmentForm  =  "Republic"

Question: How many countries have governments that are republics?
SQL: SELECT count(*) FROM country WHERE GovernmentForm  =  "Republic"

Question: What is the total surface area of the countries in the Caribbean region?
SQL: SELECT sum(SurfaceArea) FROM country WHERE Region  =  "Caribbean"

Question: How much surface area do the countires in the Carribean cover together?
SQL: SELECT sum(SurfaceArea) FROM country WHERE Region  =  "Caribbean"

Question: Which continent is Anguilla in?
SQL: SELECT Continent FROM country WHERE Name  =  "Anguilla"

Question: What is the continent name which Anguilla belongs to?
SQL: SELECT Continent FROM country WHERE Name  =  "Anguilla"

Question: Which region is the city Kabul located in?
SQL: SELECT Region FROM country AS T1 JOIN city AS T2 ON T1.Code  =  T2.CountryCode WHERE T2.Name  =  "Kabul"

Question: What region is Kabul in?
SQL: SELECT Region FROM country AS T1 JOIN city AS T2 ON T1.Code  =  T2.CountryCode WHERE T2.Name  =  "Kabul"

Question: Which language is the most popular in Aruba?
SQL: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T1.Name  =  "Aruba" ORDER BY Percentage DESC LIMIT 1

Question: What language is predominantly spoken in Aruba?
SQL: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T1.Name  =  "Aruba" ORDER BY Percentage DESC LIMIT 1

Question: What are the population and life expectancies in Brazil?
SQL: SELECT Population ,  LifeExpectancy FROM country WHERE Name  =  "Brazil"

Question: Give me Brazil’s population and life expectancies.
SQL: SELECT Population ,  LifeExpectancy FROM country WHERE Name  =  "Brazil"

Question: What are the region and population of Angola?
SQL: SELECT Population ,  Region FROM country WHERE Name  =  "Angola"

Question: What region does Angola belong to and what is its population?
SQL: SELECT Population ,  Region FROM country WHERE Name  =  "Angola"

Question: What is the average expected life expectancy for countries in the region of Central Africa?
SQL: SELECT avg(LifeExpectancy) FROM country WHERE Region  =  "Central Africa"

Question: How long is the people’s average life expectancy in Central Africa?
SQL: SELECT avg(LifeExpectancy) FROM country WHERE Region  =  "Central Africa"

Question: What is the name of country that has the shortest life expectancy in Asia?
SQL: SELECT Name FROM country WHERE Continent  =  "Asia" ORDER BY LifeExpectancy LIMIT 1

Question: Give the name of the country in Asia with the lowest life expectancy.
SQL: SELECT Name FROM country WHERE Continent  =  "Asia" ORDER BY LifeExpectancy LIMIT 1

Question: What is the total population and maximum GNP in Asia?
SQL: SELECT sum(Population) ,  max(GNP) FROM country WHERE Continent  =  "Asia"

Question: How many people live in Asia, and what is the largest GNP among them?
SQL: SELECT sum(Population) ,  max(GNP) FROM country WHERE Continent  =  "Asia"

Question: What is the average life expectancy in African countries that are republics?
SQL: SELECT avg(LifeExpectancy) FROM country WHERE Continent  =  "Africa" AND GovernmentForm  =  "Republic"

Question: Give the average life expectancy for countries in Africa which are republics?
SQL: SELECT avg(LifeExpectancy) FROM country WHERE Continent  =  "Africa" AND GovernmentForm  =  "Republic"

Question: What is the total surface area of the continents Asia and Europe?
SQL: SELECT sum(SurfaceArea) FROM country WHERE Continent  =  "Asia" OR Continent  =  "Europe"

Question: Give the total surface area covered by countries in Asia or Europe.
SQL: SELECT sum(SurfaceArea) FROM country WHERE Continent  =  "Asia" OR Continent  =  "Europe"

Question: How many people live in Gelderland district?
SQL: SELECT sum(Population) FROM city WHERE District  =  "Gelderland"

Question: What is the total population of Gelderland district?
SQL: SELECT sum(Population) FROM city WHERE District  =  "Gelderland"

Question: What is the average GNP and total population in all nations whose government is US territory?
SQL: SELECT avg(GNP) ,  sum(population) FROM country WHERE GovernmentForm  =  "US Territory"

Question: Give the mean GNP and total population of nations which are considered US territory.
SQL: SELECT avg(GNP) ,  sum(population) FROM country WHERE GovernmentForm  =  "US Territory"

Question: How many unique languages are spoken in the world?
SQL: SELECT count(DISTINCT LANGUAGE) FROM countrylanguage

Question: What is the number of distinct languages used around the world?
SQL: SELECT count(DISTINCT LANGUAGE) FROM countrylanguage

Question: How many type of governments are in Africa?
SQL: SELECT count(DISTINCT GovernmentForm) FROM country WHERE Continent  =  "Africa"

Question: How many different forms of governments are there in Africa?
SQL: SELECT count(DISTINCT GovernmentForm) FROM country WHERE Continent  =  "Africa"

Question: What is the total number of languages used in Aruba?
SQL: SELECT COUNT(T2.Language) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T1.Name  =  "Aruba"

Question: How many languages are spoken in Aruba?
SQL: SELECT COUNT(T2.Language) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T1.Name  =  "Aruba"

Question: How many official languages does Afghanistan have?
SQL: SELECT COUNT(*) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T1.Name  =  "Afghanistan" AND IsOfficial  =  "T"

Question: How many official languages are spoken in Afghanistan?
SQL: SELECT COUNT(*) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T1.Name  =  "Afghanistan" AND IsOfficial  =  "T"

Question: What is name of the country that speaks the largest number of languages?
SQL: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode GROUP BY T1.Name ORDER BY COUNT(*) DESC LIMIT 1

Question: Give the name of the nation that uses the greatest amount of languages.
SQL: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode GROUP BY T1.Name ORDER BY COUNT(*) DESC LIMIT 1

Question: Which continent has the most diverse languages?
SQL: SELECT T1.Continent FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode GROUP BY T1.Continent ORDER BY COUNT(*) DESC LIMIT 1

Question: Which continent speaks the most languages?
SQL: SELECT T1.Continent FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode GROUP BY T1.Continent ORDER BY COUNT(*) DESC LIMIT 1