CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 49

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.
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 single column in the format of ―city, ST‖ with a heading of
Location, order_id and order date for orders that have not shipped.