java language

urgently solution required

c) Please answer the following queries based on the emptable. SQL> select * from emp JOB SAL COMM DEPTNO see 20 3ee 500 30 EMPNO ENAME -------- 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS MGR HIREDATE ---- ---====== 7902 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 02-APR-81 7698 28-SEP-81 7839 31-MAY-81 7839 09-JUN-81 7566 19-APR-87 17-NOV-81 7698 08-SEP-81 7788 23-MAY-87 1400 CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK 30 1600 1250 2975 1250 2850 2450 3eee 5000 1500 1100 10 20 10 3e 20 A EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7900 JAMES 7902 FORD 7934 MILLER CLERK ANALYST CLERK 7698 03-DEC-81 7566 03-DEC-81 7782 23-JAN-82 950 3000 1300 30 20 10 14 rows selected. SQL> select distinct job from emp: B JOB JOB D JOB JOB CLERK SALESMAN PRESIDENT MANAGER ANALYST CLERK SALESMAN PRESIDENT CLERK SALESMAN PRESIDENT CLERK SALESMAN PRESIDENT CLERK CLERK ANALYST SALESMAN SQL> select count(distinct job) from emp, A COUNT(DISTINCTJOB) COUNT(DISTINCTJOB) B D COUNT(DISTINCTJOB) COUNT(DISTINCTJOB) 4 5 6 3 SQL> select ename from emp where sal > 3000; ENAME B ENAME ENAME D ENAME KING FORD JONES SCOTT SQL> select ename from emp where deptno = 10 order by ename desc; ENAME B ENAME ENAME D ENAME CLARK KING MILLER MILLER KING CLARK MILLER CLARK KING KING MILLER CLARK SQL> select avg(sal) from emp where deptno = 20; A B AVG(SAL) AVG(SAL) AVG(SAL) D AVG(SAL) 2175 2916.66667 1566.66667