This is the end of Lab 5.--------------------------------------------------------------------------------------- CIS 336 iLab7 Working with Views
CIS-336: Lab7: Working with Views
the manager _ id field of the employee reporting to that manager. In order to produce a list of which managers supervise which employees, the table may be joined to itself using these two attributes( employee _ id, manager _ id). This is known as a SELF-JOIN. Use a SELF-JOIN on the employees table to produce a result containing two 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