Select unit _ price as“ Retail Price“ from items; – this does NOT work in EDUPE MySQL.
Any of the following WILL WORK: Select unit _ price as“ RetailPrice” from items; Select unit _ price as“ Retail _ Price” from items; Select unit _ price as Retail _ Price from items; Select unit _ price as RetailPrice from items;
** Any calculated fields MUST be given an alias( and note above NO SPACES in alias). For example:
select unit _ price * 2 from items; – this does NOT work in EDUPE MySQL
This will work: select unit _ price * 2 as NewPrice from items; Deliverables
• Lab Report( Answer Sheet) containing both the student-created SQL command( s) for each exercise, and the output showing the results obtained. Be sure your name is on the file.
LAB STEPS: Complete each of the exercises below.
1. Write a query to determine the total number of items on each order. Display the order _ id and the total with a heading of TotalItems( note no spaces). Filter to only display information for order _ id of 600 or higher.
2. Re-do query 1 but filter to only show those orders with more than 2 items ordered. Sort by the number of items ordered, lowest to highest.