Write  SQL query that shows all the columns in the country table for the North America region. The results need to be sorted in ascending order by population 

2. Write  SQL query that shows the unique regions in the country table except for the regions from the continent of Oceania. The results need to be sorted in ascending order by region 

3. Write  SQL query that shows the unique language from the Countrylanguage table where the percentage is between 1.0 and 5.0. 

4. Write  SQL query that shows the Name, Continent, Surface Area, LocalName where the LocalName ends with the word 'Island' and the surface area is greater than 100 

5. Write  SQL query that shows the country name of countries that have missing values for IndepYear and GNPOld 

6. Write  SQL query that shows the maximum population with an alias of Maxpopulation and minimum population with an alias of MinPopulation for the North America region 

7. Write  SQL query that shows each region once and the total number of countries in the region with an alias of TotalCountries and the total population with an alias of TotalPopulation in that region. The results should be sorted in ascending order by region 

8. Write  SQL subquery that shows the unique region names where the languages spoken are English, French or German. 

9. Write  SQL query that shows the country name, region, language for the Caribbean region 

10. Write  SQL query that shows the country name once and shows the number of cities in that country. The number of cities in the country is from the City table and should have an alias of NumberofCity. 

11. Write  SQL query that shows the country name and number of official languages with an alias NumberOfficial. Please note the condition is asking for the count where IsOfficial is true. The results need to be sorted by number of official languages (NumberOfficial) in descending order. 

12. Write  SQL query that shows the country name and number of official languages with an alias NumberOfficial. Please note the condition is asking for the count where IsOfficial is true. Also, the results should show only if the count of the number of official languages is greater than 2. The results need to be sorted by number of official languages (NumberOfficial) in descending order.