Do you actually expect us to do your homework?

If you want to learn, you should at least try to code the query on your own -- that is the purpose of homework!