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.

Programming

Complete the following exercises using SQLite Studio.

1. 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.

1. 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.

 

1. 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.

 

1. 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.

 

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

 

Id	Customer	Street Address	City	State	Zip
1	Bill Smith	123 Main Street	Hope	CA	98764
2	Mary Smith	123 Dorian Street	Harmony	AZ	98433
3	Bob Smith	45 Osage Avenue	Humor	CA	98212
4	Elias Suarez	10 Albany Drive	Louviers	LA	98765
5	Kareem Diop	233 Crescent Ave.	Pronto	AL	NULL
6	Karla Satinsky	201 Hudson Park Rd	Muller	NY	10026

 

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