you can't use an aggregate function like COUNT() in the WHERE clause
you can't use an aggregate function without a GROUP BY clause unless you're counting all rows
what you want to achieve (a rank for a specific row) will require sql that looks like this -- http://www.sitepoint.com/forums/showpost.php?p=4782963&postcount=2
you might also want to send a message to flower.pink19 as it appears you are both working on the same homework assignment
how interesting that both of you seem to have "flower" in your user names...