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