The following question are based on the database whose relational schemas are emp(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) and DEPT(DEPTNO, DNAME, LOC). (a) Update employee SMITH’s job and...

The following question are based on the database whose relational schemas are emp(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) and DEPT(DEPTNO, DNAME, LOC).

(a)  Update employee SMITH’s job and salary to match that of employee WARD.
(b)   List the employees joined in Jan with salary ranging from 1500 to 4000.

(c)   Find out the names and salaries of employees whose salaries greater than salaries of their managers.
(d) Find out the manager’s name and number of employees who is having maximum number of employees working under him.