Using the database(SQL), write the queries for all the following questions. More information is provided at the end EMPNO ENAME JOB MGR HIREDATE SALCOMM DEPTNO 1 7369 SMITH CLERK 7902 17/12/80 800 (null) 20 2 7499 ALLEN SALESMAN 7698 20/02/81 1600 300 30 3 7521 WARD SALESMAN 7698 22/02/81 1250 500 30 4 7566 JONES MANAGER 7839 02/04/81 2975 (null) 20 5 7654 MARTIN SALESMAN 7698 28/09/81 1250 1400 30 6 7698 BLAKE MANAGER 7839 01/05/81 2850 (null) 30 7 7782 CLARK MANAGER 7839 09/06/81 2450 (null) 10 8 7788 SCOTT ANALYST 7566 09/12/82 3000 (null) 20 9 7839 KING PRESIDENT (null) 17/11/81 5000 (null) 10 10 7844 TURNER SALESMAN 7698 08/09/81 1500 @ 30 11 7876 ADAMS CLERK 7788 12/01/83 1100 (null) 20 12 7900 JAMES CLERK 7698 03/12/81 950 (null) 30 13 7902 FORD ANALYST 7566 03/12/81 (null) 20 14 7934 MILLER CLERK 7782 23/01/82 1300 (null) 10 NMON 3000 a 1. From the Emp table, write a query to find those employees working under the managers 7902 or 7698 or 7788 or 7782. Retum complete information about the employees. 2. From the Emp table, write a query to find those employees who joined in 80's. Return complete information about the employees. 3. From Emp, Dept, Salgrade tables, write a query to find those employees who eam 60000 in a year or not working as an ANALYST. Return employee name, job name, (12*salary) as Annual Salary, department no, and grade. 4. From Emp, Salgrade tables, write a query to find the name and salary of the employee SCOTT. Salary should be equal to the highest salary within his or her salary group. 5. From the Emp table, write a query to find those employees who are working either as a MANAGER or an ANALYST with a salary in the range 2000, 5000 (Begin and end values are included.) without any commission. Return complete information about the employees. 6. From Emp, Dept, Salgrade tables, write a query to find those employees of SALES department come from CHICAGO or DALLAS within the grade 3,4, and 5 and experience over 40 years. Return department no, employee no, employee name, salary, department name, department location and grade. 7. From Emp, Dept tables, write a query to list employees in ascending order on department no and descending order on jobs. Return complete information about the employees. 8. From Emp table, write a query to find the employees in the ascending order of their annual salary. Return employee no, employee name, salary, salary/30 as Daily_Salary, and 12*salary as Anual_Salary