• Use GROUP BY. If you show us what you've tried so far, we can show you where you're going wrong.

    John