$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 $10000$st 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 ofeach 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 CD$33$ and item DL$51,$ 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 Engine.

$15.$ List the order number and order date for each order that either was placed by Almondton General Store or that contains an order line for a Fire Engine.

$16.$ List the order number and order date for each order that was placed by Almondton General Store and that contains an order line for a Fire Engine.

$17.$ List the order number and order date for each order that was placed by Almondton General Store but that does not contain an order line for a Fire Engine.

$18.$ List the item number, description, unit price, and category for each item that has a unit price greater than the unit price ofevery item in category GME. Use either the ALL or ANY operator in your query. $($Hint: Make sure you select the correct operator.$)$

$19.$ For each item, list the item number, description, units on hand, order number, and number of units ordered. All items should be included in the results. For those items that are currently not on order, the order number and number of units ordered should be left blank.

Order the results by item number.