database

8) Design a query to Display PID, Pname, job, Ename where job is lecturer and Location is South 9) Design a query to Display EID, Ename, job where job is Driver OR PID=11. [3.5 Marks) [3.5 10) Using total rows, find the SUM of benefits from employee table. [3 Marks) Use SQL only- 10 marks 11) With a SQL statement to Update job from "HOSto "HOD' Where EID is EMPOS in Employee table. [ 4 Marks 12) With a SQL statement Insert following record in Employee Table [ 4 Marks EID EMP06 Ename Job Sarah Lecturer Salary 2000.0 Benefits Joiningdate 10 17-Jan-20 PID 33