Part 3 will require you to create your own SQL statements to satisfy the information requirements as outlined in this lab. Prior to completing this part of the lab; You should add additional test data to your database as needed in order to test your SQL statements.
Select Queries
Note: Do not use any foreign keys in the select list for any SQL statement.
1. S2_8
a. Create a list of customer names and their respective credit card numbers, credit card expiry date, city and province in the result set. Sort the information by city within province.
2. S2_9
a. Create a list of manufacturers names where the manufacturer name ends in ‘E’. Sort the information by manufacturers name in descending order.
3. S2_10
a. Create a distinct list of customer names for customers that live in Manitoba or British Columbia.
4. S2_11
a. Create a list of inventory items, MSRP price, price paid from the order details and calculate the difference between the two prices.
5. S2_12
a. Create a list of ship-to-city, order dates and ship dates. Sort the information by Ship-to-city and order dates.
fgr994
1120_14w_isqllab_changes.docx
0
