Instructions for joining tables activity - Instructions 1 2 3 4 5 Open orders database which is stored in common folder Copy all of its contents and

Instructions for joining tables activity - Instructions 1 2...

This preview shows page 1 - 2 out of 2 pages.

Instructions: 1. Open “orders database.txt” which is stored in common folder. 2. Copy all of its contents and paste it into your SQL worksheet. 3. Run the script. 4. Examine the tables and its contents. 5. Write a SELECT statement for each of the following a.Who among the customers placed an order on November 2015?Last NameFirst NameOrder DateWangKhoCo b.What products were ordered on November 2015?Product IDProduct NameOrder Date202203203206207201205210 c.Who among the customers ordered a printer? For customer name, concatenate the first name and last name separated by a space. Suppressduplicate rows.Customer NameNelly Co d.What is the total quantity ordered for each product? Include those products that were never ordered. Sort the list according to total quantity
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '14
  • According to Jim, Separated sets, HP LaserJet

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes