Sales Orders Database
Customer Liz Keyser wants to order again the products ordered on December 11, 2012. Use June 12, 2013, as the order date and June 15, 2013, as the shipped date. (Hint: You need to copy rows in both the Orders and Order_Details tables. Assume that you can add 1000 to the OrderID column value that you find for the December 11 order for Liz Keyser to generate the new order number.) (1 & 4 rows added)
Create a new customer record for Mary Baker at 7834 W 32nd Ct., Bothell, WA, 98011, with area code 425 and phone number 555-9876. (1 row added).
Delete any categories that have no products. (1 row deleted)
Entertainment Agency Database
Agent Marianne Wier would like to book somee ntertainers, so create a new customer record by copying relevant fields from the Agents table. (Hint: Simply copy the relevant columns from the Agents table to the Customers table.) (1 row added)
Add ‘NewAge’ to the list of musical styles. (1 row added)
Delete members who are not part of an entertainment group. (no rows deleted)
School Scheduling Database
- Angel Kennedy wants to register as a student. Her husband, John, is already enrolled. Create a new student record for Angel using the information from John’s record. (1 row added)
Bowling League Database
- Delete all bowling matches that have not been played. (1 row deleted)