CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 71

concatenated last_name and first_name of the manager, and the
concatenated last_name and first_name of the employee. Label the
first-column supervisor, and the second-column employee. Order the
output by the supervisor’s last_name and first_name.
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