CIS 336 All Assignments CIS 336 All Assignments | Page 49

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 iLab 6 Group Functions and Subqueries
Click Below Link To Purchase
www.foxtutor.com/product/cis-336-ilab-6-group-functions-and-
subqueries
CIS336: Lab 6: Group Functions and Subqueries
LAB OVERVIEW
Scenario and Summary
Lab 6 will introduce the concept of group functions and subqueries to meet more complex
report requirements. 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 CreateOMTables.docx to create your database, tables, and data.
A few IMPORTANT things to note if using EDUPE MySQL: