please send the screenshot of the SQL work you did
and explain the answer
but send the SQL screenshot of answer and steps
http://apex.oracle.com
TAL Distributors Use SQL and the TAL Distributors database (see Figure 1-2 in Chapter 1) to complete the following exercises. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output or save it to a document. 1. For each order, list the order number and order date along with the number and name of 2. For each order placed on October 15, 2015, list the order number along with the number 3. For each order, list the order number, order date, item number, number of units ordered, 4. Use the IN operator to find the number and name of each customer that placed an order the customer that placed the order and name of the customer that placed the order and quoted price for each order line that makes up the order on October 15, 2015. 5. Repeat Exercise 4, but this time use the EXISTS operator in your answer 6 Find the number and name of each customer that did not place an order on October 15, 2015. 7. For each order, list the order number, order date, item number, description, and category for each item that makes up the order 8. Repeat Exercise 7, but this time order the rows by category and then by order number 9. Use a subquery to find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit of $10,000. List each sales rep only once in the results 10. Repeat Exercise 9, but this time do not use a subquery 11. Find the number and name of each customer that currently has an order on file for a Rocking Horse 12. List the item number, description, and category for each pair of items that are in the same category. (For example, one such pair would be item CD33 and item DL51, because the category for both items is TOY.) 13. List the order number and order date for each order placed by the customer named Johnson's Department Store. (Hint: To enter an apostrophe (single quotation mark) within a string of characters, type two single quotation marks.) 14. List the order number and order date for each order that contains an order line for a Fire TAL Distributors Use SQL and the TAL Distributors database (see Figure 1-2 in Chapter 1) to complete the following exercises. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output or save it to a document. 1. For each order, list the order number and order date along with the number and name of 2. For each order placed on October 15, 2015, list the order number along with the number 3. For each order, list the order number, order date, item number, number of units ordered, 4. Use the IN operator to find the number and name of each customer that placed an order the customer that placed the order and name of the customer that placed the order and quoted price for each order line that makes up the order on October 15, 2015. 5. Repeat Exercise 4, but this time use the EXISTS operator in your answer 6 Find the number and name of each customer that did not place an order on October 15, 2015. 7. For each order, list the order number, order date, item number, description, and category for each item that makes up the order 8. Repeat Exercise 7, but this time order the rows by category and then by order number 9. Use a subquery to find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit of $10,000. List each sales rep only once in the results 10. Repeat Exercise 9, but this time do not use a subquery 11. Find the number and name of each customer that currently has an order on file for a Rocking Horse 12. List the item number, description, and category for each pair of items that are in the same category. (For example, one such pair would be item CD33 and item DL51, because the category for both items is TOY.) 13. List the order number and order date for each order placed by the customer named Johnson's Department Store. (Hint: To enter an apostrophe (single quotation mark) within a string of characters, type two single quotation marks.) 14. List the order number and order date for each order that contains an order line for a Fire
