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 .
3 . Use the implicit join syntax ( the WHERE clause ) to display the last name , city , order date and ship date for all orders shipped in 2012 .
4 . Use any join syntax EXCEPT NATURAL JOIN to list the customer _ first _ name and customer _ last _ name concatenated with an intervening space as Customer , customer city and state formatted as a