This sounds a bit like a school work type question so without wanting to give too much of an answer I'd suggest you look at the GROUP BY clause - that should help you find the answer.