Collect and enter 30 records with complete data, related to your topic of interest from your Practical App 1.
Perform SELECT statements on the data in a manner that follows your lecture and lab activities, capture and
submit screenshots of the Queries and resulting tables.
For the lecture we were provided a world database with country and city tables to run basic queries against.
We were also provided a list of around 50 queries to run. Below, I have selected some examples.
Write a query that will display all of the fields for all rows in the Country table.
Write a query that will display the Country Name and Form of Government for all the rows in the Country Table.
Write a query that will display all the fields for all countries that won independence after 1900.
Write a query that will display all the fields for all countries with a population between one and two million.
Write a query that will display the name of the country and the continent it is part of where the GNP is less than 1000.
Write a query that will display the name of the country and the continent it is part of where the GNP is less than 1000 and limit the return to such countries on the Asian and African continents.
Write a query that will display the Country Code and Name for all countries for which English is the official language.
Write a query that will display the names and population of African countries in descending order by population.