Request modelling

[Nils Valentin]

Hi MySQL Fans ;-)

I would like to list all courses with have less than lets say 10 participants.
Does anybody know how I would have to modify the code below to get this to
work ?

schedule_id is the course itself
SELECT schedule_id,count(schedule_id) FROM attendance WHERE
count(schedule_id)<10 GROUP BY schedule_id ;

My problem is that I would need to use the count function actually within the
WHERE (clause which is not allowed).

I would appreciate any help or workaround.

--
---
Valentin Nils
Internet Technology

E-Mail: ni**@knowd.co.jp
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw