Please query data from emp table to generate following identical result (display each employee's manager name as "Mgr Name", his or her total employee number as "Total Emp", and total salary cost as Total Sal Cost" under his or her department): gr Name Total Emp Total Sal Cost 1300 1100 800 6000 8275 6550 1 CLARK SCOTT FORD ONES KING BLAKE 2 3 5 Please query data from emp table and dept table to generate following identical result (display eachdept's loc as "Dept Loc and each dept's manager name as "Mgr Name", count each dept's employee number as "Total Emp", calculate each dept's salary cost as "Total Sal Cost", and calculate each dept's average salary cost as Average San ept Loc Mgr Name Total Emp Total Sal Cost Average Sal HICAGO ALLAS ALLAS ALLAS EW YORK BLAKE FORD JONES SCOTT CLARK 5 1 2 1 1310 800 3000 1100 1300 800 1100 1300