Question: Create one.sql file with SQL queries that executes the requirements noted below. Make sure you have comments in your sql in the beginning providing
Create one.sql file with SQL queries that executes the requirements noted below. Make sure you have comments in your sql in the beginning providing your name, course/course section, and CWID. (points deducted for not having this comment) 1. Use the salesordersDB database schema. 2. 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.
Step by Step Solution
3.33 Rating (153 Votes )
There are 3 Steps involved in it
Heres an SQL file that fulfills the requirements youve provided Please make sure to replace YourName ... View full answer
Get step-by-step solutions from verified subject matter experts
