Question: Write a query to display the manager name, department name, department phone number, employee name, customer name, invoice date, and invoice total for the department

Write a query to display the manager name, department name, department phone number, employee name, customer name, invoice date, and invoice total for the department manager of the employee who made a sale to a customer whose last name is Hagan on May 18, 2021 (Figure P7.47).

Figure P7.47 Manager of Employee Making a Sale to Customer Hagan Manager FName Manager LName | DEPT_NAME

Figure P7.47 Manager of Employee Making a Sale to Customer Hagan Manager FName Manager LName DEPT_NAME DEPT PHONE Employee Fname Employee Lname Customer FName Customer LName INV_DATE INV_TOTAL FRANKLYN STOVER SALES 555-2824 THURMAN WILKINSON DARELL HAGAN 315.04 5/18/2021

Step by Step Solution

3.35 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

SELECT FROM JOIN JOIN JOIN JOIN JOIN ManagerFirstName AS ManagerFName Manager Last Name AS ManagerLN... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database Systems Design Implementation Questions!