1. Write a SQL query that shows all the columns in the Country table where the IndepYear is less than or equal to 1900.

[answerhappygod]

1 Write A Sql Query That Shows All The Columns In The Country Table Where The Indepyear Is Less Than Or Equal To 1900 1 (41.88 KiB) Viewed 40 times

1 Write A Sql Query That Shows All The Columns In The Country Table Where The Indepyear Is Less Than Or Equal To 1900 2 (41.88 KiB) Viewed 40 times

1 Write A Sql Query That Shows All The Columns In The Country Table Where The Indepyear Is Less Than Or Equal To 1900 3 (52.58 KiB) Viewed 40 times

1. Write a SQL query that shows all the columns in the Country table where the IndepYear is less than or equal to 1900. The results need to be sorted in ascending order by population 2. Write a SQL query that shows the unique regions (each region should appear only once) in the Country table. The results need to be sorted in descending order by region 3. Write a SQL query that shows the unique language from the Countrylanguage table where the percentage is between 50.0 and 80.0. 4. Write a SQL query that shows the Name, Continent, Surface Area, LocalName from the Country table where the LocalName ends with the word 'island' and the surface area is less than 50. 5. Write a SQL query that shows the country name of countries that have null (missing) values for IndepYear and GNPOld
6. Write a SQL query that shows the minimum population from the Country table with an alias of MinPopulation for the North America region and the maximum population from the country table with an alias MaxPopulation. 7. Write a SQL query that shows each region once and the count of the number of countries in the region with an alias of TotalCountries. The results should be sorted in descending order by the count of the number of countries. 8. Write a SQL query that shows each region once and the count of the number of countries in the region with an alias of TotalCountries. The results should show only if the count of the total countries in the region is 15 and below. The results should be sorted in descending order by the count of the number of countries. 9. Write a SQL subquery that shows the unique region names from the Country table where the languages spoken in the countries are English, Spanish OR Italian. The results need to be sorted in ascending order by region. (For this query, please write the query using a subquery to get points). 10. Write a SQL query that shows the Country Name, Population, Life Expectancy, GNP, Language for countries in the Caribbean Region AND where language is English. The results need to be sorted by Population in descending order.