[solved]-10 Write Query Display Employee S Number First Last Name Department Name First Last Name M Q39011679
10. Write a query to display each employee’s number, first andlast name, department name, and the first and last name of theirmanager. Sort the results by employee number.
FIGURE P7.27 THE CHOZ_LARGECO ERD LGCUSTOMER PK Cust Code LGBRAND PK Brand ID Cust_Fname Cust_Lname Cust_Street Cust_City Cust_State Cust_ZIP Cust_Balance Brand_Name Brand_Type 누 includes places LGLINE LGPRODUCT PK Prod SKU LGINVOICE Iny Num PK PK,FK1 Iny Num PK Line Num be appears on H he contains FK2 FK1 Cust_code Inv_Date Inv_Total FK2 Employee_ID Prod_SKU Line_Qty Line_Price Prod_Descript Prod_Type Prod_Base Prod_Category Prod_Price Prod_QOH Prod_Min Brand_ID FK1 completes provided by LGEMPLOYEE PK Emp Num LGSALARY_HISTORY PK,FK1 Emp Num # has KPK Sal From LGSUPPLIES PK,FK1 Vend ID PK,FK2 Prod SKU Emp_Fname Emp_Lname Emp_Email Emp_Phone Emp_Hiredate Emp_Title Emp_Comm Dept_Num Sal_End Sal_Amount FK1 provides employs mankges LGVENDOR PK Vend ID LGDEPARTMENT PK Dept Num Vend_Name Vend_Street Vend_City Vend_State Vend_ZIP Dept_Name Dept_Mail_Box Dept_Phone FK1 Emp_Num Show transcribed image text FIGURE P7.27 THE CHOZ_LARGECO ERD LGCUSTOMER PK Cust Code LGBRAND PK Brand ID Cust_Fname Cust_Lname Cust_Street Cust_City Cust_State Cust_ZIP Cust_Balance Brand_Name Brand_Type 누 includes places LGLINE LGPRODUCT PK Prod SKU LGINVOICE Iny Num PK PK,FK1 Iny Num PK Line Num be appears on H he contains FK2 FK1 Cust_code Inv_Date Inv_Total FK2 Employee_ID Prod_SKU Line_Qty Line_Price Prod_Descript Prod_Type Prod_Base Prod_Category Prod_Price Prod_QOH Prod_Min Brand_ID FK1 completes provided by LGEMPLOYEE PK Emp Num LGSALARY_HISTORY PK,FK1 Emp Num # has KPK Sal From LGSUPPLIES PK,FK1 Vend ID PK,FK2 Prod SKU Emp_Fname Emp_Lname Emp_Email Emp_Phone Emp_Hiredate Emp_Title Emp_Comm Dept_Num Sal_End Sal_Amount FK1 provides employs mankges LGVENDOR PK Vend ID LGDEPARTMENT PK Dept Num Vend_Name Vend_Street Vend_City Vend_State Vend_ZIP Dept_Name Dept_Mail_Box Dept_Phone FK1 Emp_Num
Expert Answer
Answer to 10. Write a query to display each employee’s number, first and last name, department name, and the first and last name o… . . .
OR
