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, 2011. For all person names, concatenate the first and last names into a singlefield.

Transcribed Image Text:

MANAGER NAME İ DEPT NAME İ DEPT PHONE İ FRANKLYN STOVER SALES EMPLOYEE NAME THURMAN WİLKINSON İ CUSTOMER NAME İ INV DATE | INV TOTAL DARELL HAGAN 555-2824 5/18/2011 315.04