Help Counting An Item

[furtech]

Hello,

I was wondering if someone could tell the correct way to go about using the count statement within a select query. I want to count students attempts at taking an exam but only show users who have done it more than 3 times...

Table: Student_Attempts
Stu_Name Attempts
Bob 3
Mary 6
Sam 8
Jane 1

Its the more than 3 times part that I'm stuck on.

Thanks,

Matthew

 

[guelphdad]

look into the use of HAVING.

 

[MillerH]

Emplying the use of 'HAVING'. The group by probably should be changed to a real primary key instead of Stu_Name which may not be unique per student.

SELECT Stu_Name, COUNT(*) AS Attempts FROM Student_Attempts GROUP BY Stu_Name HAVING Attempts >= 3;