Assignment: Please post the following in the class dropbox NLT 11:59 pm, 07 April: .

Translate the requirements below into a SQL query that accomplishes the following:

-a. Management requested an output of all orders, the products in each order, and the amount owed for each product. In addition, the requirement was to provide the output sorted by number sequence. Make sure it looks exactly like the example output (at the back of this assignment). Requirement: Must use a JOIN. Hint: 1000 rows returned.

-b. Management wants to see a list of each product to include the product name and the total sales of each. Make sure it looks exactly like the example output (at the back of this assignment). Requirement: Must use JOIN. Hint: 38 rows returned.

3. Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted.

4. Be sure and meet both explicit requirements as noted in the requirements statement as well as implicit requirements that are provided in the output grid.

Note: Required output noted below may not have all rows shown. \begin{tabular}{l|l} \hline ProductName & TotalSales \\ \hline Trek 9000 Mountain Bike & 2192616.00 \\ GT RTS-2 Mountain Bike & 1109542.50 \\ Viscount Mountain Bike & 400678.65 \\ Eagle FS-3 Mountain Bike & 124002.00 \\ AeroFlo ATB Wheels & 75458.25 \\ Ultimate Export 2G Car Rack & 64728.00 \\ Road Warrior Hitch Pack & 64277.50 \\ Cosmic Elite Road Warrior Wheels & 63803.85 \\ Cycle-Doc Pro Repair Stand & 62157.04 \\ King Cobra Helmet & 57572.41 \\ \hline \end{tabular} Note: Required output noted below may not have all rows shown. \begin{tabular}{l|l} \hline ProductName & TotalSales \\ \hline Trek 9000 Mountain Bike & 2192616.00 \\ GT RTS-2 Mountain Bike & 1109542.50 \\ Viscount Mountain Bike & 400678.65 \\ Eagle FS-3 Mountain Bike & 124002.00 \\ AeroFlo ATB Wheels & 75458.25 \\ Ultimate Export 2G Car Rack & 64728.00 \\ Road Warrior Hitch Pack & 64277.50 \\ Cosmic Elite Road Warrior Wheels & 63803.85 \\ Cycle-Doc Pro Repair Stand & 62157.04 \\ King Cobra Helmet & 57572.41 \\ \hline \end{tabular}