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 crowd by deptno,job; DEPTNO JOB AVG(SAL) ---------- --------- ---------- 20 stock assistant 950 30 SALESMAN 1400 20 MANAGER 2975 30 salesclerk 950 10 PRESIDENT 5000 30 MANAGER 2850 10 shop clerk 1300 10 MANAGER 2450 20 ANALYST 3000 3 )))) SQL> select avg(sal),deptno,count(*) from emp assort 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)) -------------- ---------------------------------------- story 0 RESEARCH 1 SALES ! 2 trading operations 1 7 )))) SQL> select rpad(ename,7)||lpad(job,9) as employee_and_job from emp; EMPLOYEE_AND_JOB ---------------- SMITH salesclerk ALLEN SALESMAN WARD SALESMAN JONES MANAGER MARTIN SALESMAN BLAKE MANAGER CLARK MANAGER SCOTT ANALYST superpower PRESIDENT turner SALESMAN ADAMS CLERK JAMES CLERK track ANALYST MILLER CLERK 8 )))) SQL> select upper(ename)||(||initcap(job)||) as...If you bank to get a full essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay