This account does not allow editing on your device. For an account with full access,... more Lab Hornework W12 the newh of each query helow each quetion: 1. Lht the first aame and lass name of empleyeeln? who are supervised by "lames Bort". Hint. Use inser query wib in operater, If there are duplications in the resulant lat thes sse DosTinct keyword in the seleCt dause of the ovter query. 2. Mow many projects do the departmerts other than the administation departinent control? tist the department rame and the namber of projects it conteds. Witt: Uve inner query with IV or NOT W operatar 3. What is the total salury paid tes the employees aviknt on the "Cemounerimion". project? Hint: Use inmer query wot E operator 4. What is the average aalary paid to the employees working on the projects other than the project Producte?? Wint: Uhe innter query with ik or NOY IN operator 5. the the first name and lant narme of enployeelo) who are superved by sapervison "7ames Bord" or "Yranklin Wone"? Hint: Uoe set operatar UNiON