CSC150
Professor McKeon-Vitelli
1
SPRING 2022 FINAL
Instructions:
1. Like weekly homework, provide the SQL query code and a snip of the table result.
2. Show the result Number of Records
3. Show the actual table results. DO NOT just show this ->
1. Show employeeid, lastname, firstname and birthdate for employees with employeeID 10 or less.
2. Update the record for CustomerID = 48, ContactName = Henry Hines, City = Reeds
3. Add this new record to the customers table:
Food King, Jennifer Brown, 33 Main Street, Bethel, 06801, USA
4. From the Orders table, show all order information where customerid is 14 and shipperid is 2;
5. Show the largest quantity ordered in the OrderDetails table.
6. Using the Customers table, how many customers do we have? HINT: use the CustomerID
7. Select all from the customers table, but show only the ContactName that begin with M and
ends with N
8. Using the Products table, find the average product price for each SupplierID, group by
SupplierID and ONLY display average prices less than $30.
9. Extract only ONE (1) instance of each City in the Customers table and Order by City
ascending.
The list will be long, show the first 10 results WITH THE Number of Records
10. Select all records in customers table, except for cities Albuquerque and Barcelona then
Order By City. (Use the NOT modifier in the where clause)
V12521

Purchase answer to see full
attachment