Sql database lab help??????????? | Computer Science homework help



Part 3


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

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

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

    1. Create a distinct list of customer names for customers that live in Manitoba or British Columbia.

  4. S2_11

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

    1. Create a list of ship-to-city, order dates and ship dates.  Sort the information by Ship-to-city and order dates.