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