look at using SQL aggregation functions
also using JOINs
using GROUP BY sub clauses
its your homework, your coursework. you really do need to make an effort to do it yourself.
if you do need help then you need to show the schema (the table designs), soem sample data
what you have tried so far
what is or isn't working
what you are stuck on.
people here may well help you, may well provide some pointers, but they won't do for you.
of course if that is too much of an issue you could alwasy send us the name of the college/school/uni and the lecturer and we could seek the details directly...
I'd rather be riding on the Tiger 800 or the Norton