DB Browser for SQLite $-$ C:$\backslash$Users$\backslash$diazd$\backslash$Downloads$\backslash$world$(5)(3).$db EXERCISES

$1$: Display a list of the continents on Earth in alphabetical order along with the number of countries per continent. Use an alias for the number of countries. Order the results alphabetically by the continent name.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$2.$ Display the countries in North America and their life expectancy, showing the name and life expectancy of each country ranked from highest to lowest.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$3.$ Display the name and population of each city in the Netherlands? Order the results in order of the highest to lowest population.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$4$: Display the name and total population of each region in the world from highest to lowest.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$5$: Display a list of countries whose official language is German. Show the names of the countries in alphabetical order.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$6$: For every region across the world, show the name of the region and the number of countries in that region with either a monarchy or a constitutional monarchy form of government. Use an alias for the number of countries. Show the names of the region in alphabetical order.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$7.$ Show the ten most popular languages based on the number of countries using each language. Show the popularity of each language ranked from highest to lowest. Use an alias for the number of countries using each language.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$$

$8$: For every government form across the world, what is the life expectancy in the countries with that government form? Display the government form followed by the average life expectancy from highest to lowest.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$9$: For each region of Europe, display its list of countries. Show the region, the name of the country, and the head of state of the country. Sort the results by region and country.

Paste your SQL query below:

$$

Paste your screenshot below:

$$

$10.$ Display all of the cities in Finland and their district. Order the results alphabetically by district and then by the cities within each district alphabetically as well.

Paste your SQL query below:

$$

Paste your screenshot below: