** There can be NO SPACES in alias names given to a column . For example :
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 that displays a list of all customers showing the customer first name , last name , and phone number . Sort the results by customer last name , then first name .