Given the SAS data set ONE:
ONEREP COST
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
The following SAS program is submitted:
proc sql; select rep, avg(cost) as AVERAGE
from one
group by rep;
quit;
The following output is desired:
REP AVERAGE
SMITH 400
Which SQL procedure clause completes the program and generates the desired output?
A. having avg(cost) < (select avg(cost) from one)
B. where avg(cost) > (select avg(cost) from one)
C. having avg(cost) > (select avg(cost) from one)
D. where calculated average > (select avg(cost) from one)
Answer: C
first, when you add the product to you cart ,you can see "promotion code",please fill in "testpassport".and click"apply".then you can enjoy 5% discount .
second,after you payment, you can get free update for one year.
last, next time you can contact with testpassport staff ,you will get more discount.
