Which SQL procedure clause completes the program and generates the desired output?

Given the SAS data set ONE:

ONE

REP 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

<insert SQL procedure clause here>

quit;

The following output is desired:

Which SQL procedure clause completes the program and generates the desired output?
A . having avg(cost) < select avg(cost) from one);
B . Having avg(cost)>(select avg(cost) from one);
C . Where avg(cost)>(select avg(cost) from one);
D . Where calculated average > (select avg(cost) from one);

View Answer

Answer: B