SQL Lab;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.;S2_8;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.;S2_9;Create a list of manufacturers names where the manufacturer name ends in ?E?. Sort the information by manufacturers name in descending order.;S2_10;Create a distinct list of customer names for customers that live in Manitoba or British Columbia.;S2_11;Create a list of inventory items, MSRP price, price paid from the order details and calculate the difference between the two prices.;S2_12;Create a list of ship-to-city, order dates and ship dates. Sort the information by Ship-to-city and order dates.
Paper#69163 | Written in 18-Jul-2015Price : $22