issue the query without the COUNT function, the GROUP BY clause, and the HAVING clause.

then tell me how many rows you get.

if you need me to give you an example of what is happening, just say so