Can't group on error.

[claro]

Greetings! I'm trying to get the top library users, when the user borrowed and returned a book 10 times or more, s/he belongs to the top library users. Here is my sql commant.

SELECT  sb.stud_Id, COUNT(sb.stud_Id) >=10 AS total
FROM    tbl_studentbook AS sb
LEFT JOIN tbl_student AS s ON s.id = sb.stud_Id
WHERE   EXISTS
        (
        SELECT   stud_Id
        FROM    tbl_studentbook
        WHERE   sbook_Borrow != '0000-00-00' AND sbook_Return != '0000-00-00'
         )
GROUP BY total 

My problem is I can't group it by total , error says that 'cant group on total' ..
My purpose upon grouping it is that it will show only the id that pass the total value of 10.

Any help? thank you.

[swampBoogie]

select stud_Id
  from tbl_studentbook
 where sbook_Return <> '0000-00-00'
 group by stud_id
having count(*) > 10

[claro]

Thak you very much for the quick response sir. I works now.