Test

1 )))) SQL> convey avg(sal) from emp assemblage by job; AVG(SAL) ---------- 1037.5 1400 5000 2758.33333 3000 2 )))) SQL> select deptno,job,avg(sal) from emp radical by deptno,job; DEPTNO JOB AVG(SAL) ---------- --------- ---------- 20 stigmatise assistant 950 30 SALESMAN 1400 20 MANAGER 2975 30 shop assistant 950 10 PRESIDENT 5000 30 MANAGER 2850 10 work 1300 10 MANAGER 2450 20 ANALYST 3000 3 )))) SQL> select avg(sal),deptno,count(*) from emp host by deptno having count(*)>3; AVG(SAL) DEPTNO COUNT(*) ---------- ---------- ---------- 1566.

66667 30 6 2175 20 5 4 )))) SQL> select sal from emp group by sal having count(sal)>1; SAL ---------- 1250 3000 SQL> select empno from emp group by empno having count(empno)>1; no rows selected 5 )))) SQL> select deptno from emp where job=ANALYST group by deptno having count(job)>=2; DEPTNO ---------- 20 6 )))) SQL> select dname,length(dname)-length(replace(dname,S)) from dept; DNAME LENGTH(DNAME)-LENGTH(REPLACE(DNAME,S)) -------------- ---------------------------------------- write up 0 RESEARCH 1 SALES ! 2 operations 1 7 )))) SQL> select rpad(ename,7)||lpad(job,9) as employee_and_job from emp; EMPLOYEE_AND_JOB ---------------- SMITH shop assistant ALLEN SALESMAN WARD SALESMAN JONES MANAGER MARTIN SALESMAN BLAKE MANAGER CLARK MANAGER SCOTT ANALYST world-beater PRESIDENT turner SALESMAN ADAMS CLERK JAMES CLERK cover ANALYST MILLER CLERK 8 )))) SQL> select upper(ename)||(||initcap(job)||) as...If you relish to get a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay