This is the end of Lab 5. =================================================== CIS 336 iLab7 Working with Views
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-
columns: the 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
Lab 7 will introduce the concept of database views. This lab may be completed using either DeVry ‟ sOmnymbus EDUPE-