Use the country table in the world database to create the code to display a list of countries in alphabetical order

Take a screenshot of your code/statement and the results to submit with the rest of the assignment.

Complete the following exercises using SQLite Studio.

Create a statement to display the following sentence:

Lehman is one of many CUNY colleges.

Give the column the title: Quick Facts

Take a screenshot of your code/statement and the results to submit with the rest of the assignment.

Use the country table in the world database to create the code to display a list of countries in alphabetical order. Take a screenshot of your code/statement and the results to submit with the rest of the assignment.

Use the country table in the world database to create the code to display only the columns name, continent, and population in descending order. Rename the name column, Country Name. Take a screenshot of your code/statement and the results to submit with the rest of the assignment.

Use the city table in the world database to create code to display a list of cities with a countrycode of NLD in alphabetical order. Take a screenshot of your code/statement and the results to submit with the rest of the assignment.

Use the ‘Insert Into’ and ‘Update’ clauses to modify the customer table in the test database to display the following:

Take a screenshot of your code/statement and the results to submit with the rest of the assignment.