World Database Schema
eecs3421country(code, name, continent, region, surfacearea, indepyear, population, lifeexpectancy, gnp, gnpold, localname, governmentform, headofstate, capital, code2)
eecs3421city(id, name, countrycode, district, population)
eecs3421countrylanguage(countrycode, countrylanguage, isofficial, percentage)
...where continent = {Asia, Europe, North America, South America, Africa, Oceania, Antarctica}

===============================================================
Questions to motivate Interactive Exploration (Querying)
===============================================================

Set 1

Q1: What is the country code of the country with name 'Canada'?

Q2: How many different languages are spoken in Canada?

Q3: What is the second most popular language spoken in Italy?.

Q4: What is the population of the capital of the country you are coming from? Report the country, the capital, its population.

Q5: What is the country with the largest number of spoken languages?


Set 2

Q1: Find the name of the country with code "LKA".

Q2: Find the name and population of the country with code "LKA".

Q3: Find the name and the population of the capital of the country with code "LKA".

Q4: Find the name and population of the countries of "Africa" with population more than 50000000 (50M or 50e6)

Q5: Find the different types of government form in the world. Report each type only one time.

Q6: Find the number of countries in the world. For each continent, find the number of countries and the average population.


Set 3

Q1: Find how many countries have "English" as their official language. The schema of the result should be (numofcountries).

Q2: Find the most popular official languages in the world. Report the 5 most popular languages and the number of countries where the language is official in a descending order of popularity. The schema of the result should be (countrylanguage, numofcountries).

Q3: Find which languages are spoken in most countries of the world. Report the 5 most popular languages and the number of countries where the language is spoken in a descending order of popularity. The schema of the result should be (countrylanguage, numofcountries).

Q4: Find the number of people that speak each language in "Canada". Report the language and the number of people that speak each language in a descenting order of popularity. The schema of the result should be (countrylanguage, numofpeople).

Q5: Find the languages that are spoken by most people in the world (irrelevant of their country of residence). Report only the languages that are spoken by more than 50M people in a descending order of popularity. The schema of the result should be (countrylanguage, numofpeople).