CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 64

13. Write a query to display the order id, order date, ship date, and
customer last name for all SHIPPED orders placed on the internet
(no employee id). Show the most recently shipped orders first.
14. Write a query that displays the order id, order date, and
employee name as a single field labeled Employee for each order
that an employee assisted with.
15. Write a query that displays the order id, order date, customer
name as a single field labeled Customer for all orders for the sales
rep Thomas Hardy, sorted by customer last name.
This is the end of Lab 5.
===========================================
CIS 336 iLab7 Working with Views
FOR MORE CLASSES VISIT
www.cis336study.com
CIS-336: Lab7: Working with Views
LAB OVERVIEW
Lab 7 will introduce the concept of database views. This
lab may be completed using either DeVry‟sOmnymbus
EDUPE-APP lab environment, or a local copy of the
MySQL database running on your own computer using
the OM database tables. The lab will utilize a set of tables
that are represented by the ERD (OM_ERD.docx) and are
created and populated by the script file
(create_OM_db.sql). Follow the instructions in the file