SHOW SQL CODE WITH OUTPUT

Question 11: 1. Consider the following table: EMP (Empno, Ename, Employer, Hiredate, Deptno) DEPT (Deptno, Dname, Loc_Id) LOCATION(Loc_Id, City) a. For each employee display the employee name and calculate the number of months between today's date and date the employee was hired. Hint. Use Datediff function. E.g. select datediff(year,'YYYY/MM/DD', 'YYYY/MM/DD') as Column_name; b. Write a query to display the name, job, department numbe and department name for all employees who work in Techno India. c. Create a procedure which updates the salaries of an employees as follows. if sal=1000 and