Query selecting Average < 650

[wylliecoyote]

I need a query that will select only those student IDs with an average amount_paid less than 650. So far I have this written out and it works for returning the data with the criteria given. What would I add to only select where the student_id is less than 650? I have been working on this for hours and can not figure it out.

Thanks.

select student_id as "StudentId", sum(amount_paid) as "Total_Paid",
min(regstrn_made_date) as "Earliest_Reg_Date",
count(*) as "Number_of_courses", avg(amount_paid) as "Average_Paid" from attendance
where offering_id in ('9111','9112','9212')
group by student_id
order by "Total_Paid" desc;

 

[PHV]

SELECT ..
FROM ...
WHERE ...
GROUP BY student_id
HAVING AVG(amount_paid) < 650
ORDER BY 2 DESC

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

select student_id as "StudentId"
, sum(amount_paid) as "Total_Paid"
,min(regstrn_made_date) as "Earliest_Reg_Date"
,count(*) as "Number_of_courses"
, avg(amount_paid) as "Average_Paid" 

from attendance

where offering_id in ('9111','9112','9212')

group by student_id
[b]
Having avg(amount_paid)<650
[/b]
order by "Total_Paid" desc;

Skip,

_{[red]Be Advised![/red] Dyslexic poets...
write inverse!}

 

[wylliecoyote]

Thank you so much! This works! I wish I would of asked this forum earlier, it would of saved me much grief!