• Yes, or use GROUP BY and HAVING. Sounds suspiciously like an interview or homework question to me.

    John