|
Posted by DA Morgan on 10/12/06 15:08
Adam Ruth wrote:
> RickyZane wrote:
>> I need a little help with an assignment....
>
> Select P_Class, COUNT(P_Class), AVG(P_Price)
> From PRODUCT
> Group by P_Class
> HAVING COUNT(P_Class) >= 3
That's not assistance ... that is the answer. Please help
instructors help students by providing hints ... not answers.
A sufficient answer would have been: "Consider using the HAVING clause."
Thank you.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Navigation:
[Reply to this message]
|