he Relational Model: Advance Topics
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.
- SAME AS #2 but use nested queries.
- 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).
- 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.
