CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 68

A few IMPORTANT things to note if using EDUPE
MySQL:
**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