Programming Question

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.