question archive In the following exercises use the data in the TAL Distributors database shown in Figure 2-1 (ATTACHED) Find the order number and order date for every order that contains part number XX34 Find the order number and order date from every order that includes an item located in storehouse number 2

In the following exercises use the data in the TAL Distributors database shown in Figure 2-1 (ATTACHED) Find the order number and order date for every order that contains part number XX34 Find the order number and order date from every order that includes an item located in storehouse number 2

Subject:BusinessPrice: Bought3

In the following exercises use the data in the TAL Distributors database shown in Figure 2-1 (ATTACHED)

  1. Find the order number and order date for every order that contains part number XX34
  2. Find the order number and order date from every order that includes an item located in storehouse number 2.
  3. SAME AS #2 but use nested queries.
  4. Use INTERSECT. List customer number, customer name for every customer who is either represented by sales rep number 15 or who currently has orders on file (CustomerNUM in ORDERS).
  5. Use MINUS. List customer number, customer name for every customer who is either represented by sales rep number 15 or who does not have orders currently on file.
  •  

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Related Questions