Assignment 3 BUSA 326 Data and Information Management Fall 2023 Instructor: Prof. Brodnax Assignment: Please post the following in the class dropbox NLT 11:00 pm, 10 Oct. Create one .sql file with SQL queries that executes the requirement 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 requirement below into a SQL query that accomplishes the following: -a. “Management wants to see all current products with an inventory value of $1200.00 or more”. Make sure it looks exactly like the example output (at the back of this assignment). Hint: 20 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. 5. As noted above, post the SQL (sql) file that executes the required query. The sql file (only 1 file submitted) must be posted in the dropbox by the due date to receive full credit. 6. Outputs for each requirement (request) is shown below. Remember, your query should generate the exact same output (including headers) as shown below. Note: Required output noted below may not have all rows shown.

  

Result Grid Filter Rows: ProductName Export: ProductNumber RetailPrice Wrap Cell Content: A InventoryValue QuantityOnHand Eagle FS-3 Mountain Bike 2 1800.00 8 14400.00 GT RTS-2 Mountain Bike 11 1650.00 5 8250.00 AeroFlo ATB Wheels 37 189.00 40 7560.00 Trek 9000 Mountain Bike 1 1200.00 6 7200.00 King Cobra Helmet 25 139.00 30 4170.00 Cosmic Elite Road Warrior Wheels 36 165.00 22 3630.00 Viscount Mountain Bike 6 6 635.00 5 3175.00