Using the database(SQL), write the queries for all the following questions. More information is provided at the end.

1. From the Emp table, write a query to find those employees whose commission is more than their salary. Return complete information about the employees.
2. From the Emp table, write a query to find those employees whose salary exceeds 3000 after giving 25% increment. Return complete information about the employees.
3. From the Emp table, write a query to find the employees manager and employee separated by the string manager of.
4. From the following table, write a query to find those employees who joined before 1st April 1981. Return employee no, employee name, hire date and salary.
5. From the Emp table, write a query to find those employees working under the manger KING. Return employee no, employee name, salary.
6. From the Emp table, write a query to find those employees whose salary is an even value. Return complete information about the employees.
7. From the Emp table, write a query to find those employees whose salary contains only three digits. Return complete information about the employees.
8. From the Emp table, write a query to find those employees who joined in any year except the month of December. Return complete information about the employees.
9. From the Emp table, write a query to find all those employees who have joined on 1st May, 20th Feb, and 3rd Dec in the year 1981. Return complete information about the employees.
10. From the Emp table, write a query to find those employees working under the managers 7902 or 7698 or 7788 or 7782. Return complete information about the employees.
11. From the Emp table, write a query to find those employees who joined in 80's. Return complete information about the employees.
12. From Emp, Dept, Salgrade tables, write a query to find those employees who earn 60000 in a year or not working as an ANALYST. Return employee name, job name, (12*salary) as Annual Salary, department no, and grade.
13. 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.
14. 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.
15. 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.
16. 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.
17. 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.
18. From Emp table, write a query to list the employees in the ascending order on job name and descending order on employee no. Return complete information about the employees.
19. From Emp table, write a query to list the unique jobs of department 20 and 30 in descending order. Return job name.
20. From Emp, Dept, Salgrade tables, write a query to find all employees except CLERK and sort the resultset in descending order by salary. Return employee name, job name, salary, grade and department name.
21. From Emp, Dept, Salgrade tables, write a query to find the average salary and average total remuneration (salary and commission) for each type of job. Return job, average salary and average total remuneration. Sort the resultset in ascending order by average salary.
22. From the Emp table, write a query to find those employees whose name is six characters in length, and ending with 'N'. Return number of employees.
23. From the Emp table, write a query to find those employees who joined in the month of where the second letter is 'A'.
24. From the Emp table, write a query to find those employees whose names contain the character set 'AR' together. Return complete information about the employees.
25. From the Emp table, write a query to find those employees who joined in any month, but the month name contain the character A. Return complete information about the employees.

Required code to generate the table:

DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE SALGRADE; create table dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept primary key (deptno) );

INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK'); INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS'); INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO'); INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');

create table emp( empno number(4,0), ename varchar2(10), job varchar2(9), mgr number(4,0), hiredate date, sal number(7,2), comm number(7,2), deptno number(2,0), constraint pk_emp primary key (empno), constraint fk_deptno foreign key (deptno) references dept (deptno) ); INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20); INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600, 300, 30); INSERT INTO EMP VALUES (7521, 'WARD', 'SALESMAN', 7698, TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30); INSERT INTO EMP VALUES (7566, 'JONES', 'MANAGER', 7839, TO_DATE('2-APR-1981', 'DD-MON-YYYY'), 2975, NULL, 20); INSERT INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN', 7698, TO_DATE('28-SEP-1981', 'DD-MON-YYYY'), 1250, 1400, 30); INSERT INTO EMP VALUES (7698, 'BLAKE', 'MANAGER', 7839, TO_DATE('1-MAY-1981', 'DD-MON-YYYY'), 2850, NULL, 30); INSERT INTO EMP VALUES (7782, 'CLARK', 'MANAGER', 7839, TO_DATE('9-JUN-1981', 'DD-MON-YYYY'), 2450, NULL, 10); INSERT INTO EMP VALUES (7788, 'SCOTT', 'ANALYST', 7566, TO_DATE('09-DEC-1982', 'DD-MON-YYYY'), 3000, NULL, 20); INSERT INTO EMP VALUES (7839, 'KING', 'PRESIDENT', NULL, TO_DATE('17-NOV-1981', 'DD-MON-YYYY'), 5000, NULL, 10); INSERT INTO EMP VALUES (7844, 'TURNER', 'SALESMAN', 7698, TO_DATE('8-SEP-1981', 'DD-MON-YYYY'), 1500, 0, 30); INSERT INTO EMP VALUES (7876, 'ADAMS', 'CLERK', 7788, TO_DATE('12-JAN-1983', 'DD-MON-YYYY'), 1100, NULL, 20); INSERT INTO EMP VALUES (7900, 'JAMES', 'CLERK', 7698, TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 950, NULL, 30); INSERT INTO EMP VALUES (7902, 'FORD', 'ANALYST', 7566, TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 3000, NULL, 20); INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK', 7782, TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL, 10);

CREATE TABLE SALGRADE (GRADE NUMBER, LOSAL NUMBER, HISAL NUMBER);

INSERT INTO SALGRADE VALUES (1, 700, 1200); INSERT INTO SALGRADE VALUES (2, 1201, 1400); INSERT INTO SALGRADE VALUES (3, 1401, 2000); INSERT INTO SALGRADE VALUES (4, 2001, 3000); INSERT INTO SALGRADE VALUES (5, 3001, 9999);

commit;

DEPTNO 20 30 30 20 1 2 3 4 5 6 7 8 9 10 11 12 13 14 EMPNO ENAME JOB MGR HIREDATE 7369 SMITH CLERK 7902 17/12/80 7499 ALLEN SALESMAN 7698 20/02/81 7521 WARD SALESMAN 7698 22/02/81 7566 JONES MANAGER 7839 02/04/81 7654 MARTIN SALESMAN 7698 28/09/81 7698 BLAKE MANAGER 7839 01/05/81 7782 CLARK MANAGER 7839 09/06/81 7788 SCOTT ANALYST 7566 09/12/82 7839 KING PRESIDENT (null) 17/11/81 7844 TURNER SALESMAN 7698 08/09/81 7876 ADAMS CLERK 7788 12/01/83 7900 JAMES CLERK 7698 03/12/81 7902 FORD ANALYST 7566 03/12/81 7934 MILLER CLERK 7782 23/01/82 SAL COMM 800 (null) 1600 300 1250 500 2975 (null) 1250 1400 2850 (null) 2450 (null) 3000 (null) 5000 (null) 1500 0 1100 (null) 950 (null) 3000 (null) 1300 (null) 30 30 10 20 10 30 20 30 20 10