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 .