Just to be clear, we don't do people's homework for them and this looks suspiciously like a homework assignment. If you want to get an answer you'll need to have a go at it yourslef and then come back to us with specific problems that you were unable to resolve.

If you need a hand getting started on querying then check the faqs at the head of this forum. There are some excellent ones on SQL which should give you all you need. W3Schools also offer an excellent set of explanations of the various SQL commands.

If this is some commercial work that you're hoping to get done then there is a section where you post a work request but people will want paying for the work they do.