Re: Group functions

BigLearner wrote:
> Haiiiiii everyone!
>
> I am a new member to this group.
>
> I have doubt on a this question. I got the answer wrong and wonder how
> it could be.
>
> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
> ------------ ------------ --------------------- --------
> ---------------- ------- ---------- --------------
> 7369 SMITH CLERK 7902 17-DEC-80 800
> 20
> 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
> 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
> 7566 JONES MANAGER 7839 02-APR-81 2975 20
> 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
> 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
> 7782 CLARK MANAGER 7839 09-JUN-81 2450 10
> 7788 SCOTT ANALYST 7566 09-DEC-82 3000 20
> 7839 KING PRESIDENT 17-NOV-81 5000
> 10
> 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
> 7876 ADAMS CLERK 7788 12-JAN-82 1100 20
> 7900 JAMES CLERK 7698 03-DEC-81 950
> 30
> 7902 FORD ANALYST 7566 03-DEC-81 3000 20
> 7934 FILLER CLERK 7782 23-JAN-82 1300
> 10
>
> Which of the following choices identifies the value tha would be
> returned from the following query: select sum(sal) + sum(comm) from emp
> where job = 'ANALYST' or ename like 'J%'?
>
> A. 6000
> B. 9925
> C. 9975
> D. NULL
>
> Which of the following choices identify the value returned by Oracle
> whn you issue the following query : select * from emp where hiredate >
> '23-JAN-82'? (Choose two.)
> A. ADAMS
> B. MILLER
> C. SCOTT
> D. SMITH
You aren't going to get any from me going forward as you are showing signs of terminal laziness and I refuse to contribute to your early death.

No Oracle version number.
No sample SQL that is generating the wrong result.

You are on your own unless you are willing to me us half-way.

I would really like to encourage you to learn Oracle ... but so far it seems you are just asking others to do your homework for you and that is not acceptable.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org