Use SQL to make the following changes to the TAL Distributors database:

$1.$ 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.

$2.$ 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.

$3.$ 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.

$4.$ 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.

$5.$ For each rep, list the customer number, customer name, rep last name, and rep first name. All reps should be included in the results. Order the results by rep number. There are two SOL commands for this query that will list the same results. Create and run each SOL command.