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. Use the JOIN ON syntax to write a query to display the order id, order date, customer name formatted as a single field( i. e. ― Tom Jones ‖) with a heading of Customer, and customer _ city for customers residing in the state of OHIO. Sort the output to display the newest orders first.
2. Use the JOIN USING syntax to display the order _ id, order date, and shipdate for orders to Karina Lacy that have shipped.