Question 3: Write SQL queries for the following Below, EMP table is given only for reference purpose. EMPNO ENAMЕ JOB MGR HIREDATE SAL COMM DEPTNO 79 02 17-DEC-80 7369 SMITH 7499 ALLEN 7521 WARD CLERK...

Extracted text: Question 3: Write SQL queries for the following Below, EMP table is given only for reference purpose. EMPNO ENAMЕ JOB MGR HIREDATE SAL COMM DEPTNO 79 02 17-DEC-80 7369 SMITH 7499 ALLEN 7521 WARD CLERK SALESMAN SALESMAN 800 1600 1250 2975 20 30 30 7698 20-FEB-81 7698 22-FEB-81 300 500 7566 JONES 7654 MARTIN MANAGER 839 02-APR-81 20 SALESMAN 7698 28-SEP-81 1250 1400 30 7839 01-MAY-81 7839 09-JUN-81 7698 BLAKE MANAGER 2850 30 7782 CLARK MANAGER 2450 10 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 20 10 30 20 ANALYST 7566 19-APR-87 3000 PRESIDENT 17-NOU-81 5000 1500 SALESMAN 7698 08-SEP-81 7788 23-MAY-87 7698 03-DEC-81 1100 950 3000 1300 CLERK 7900 JAMES CLERK 30 7902 FORD ANALYST 7566 03-DEC-81 7782 23-JAN-82 20 7934 MILLER CLERK 10 (i) mgr=null, ename=3rd character is N, not known anything else (ii) Give single example with sql queries for each of the following single-row function CONCAT, INSTR, RPAD, TRIM? (iii) Write an sql query for: SAL not greater than 3000 and JOB has third character "A" in the string and ha commission. (iv) Display employee record before 20-APR-1985. (v) Display only names and salaries of those employees whose salary is between 12 2000.