Create SQL queries in MS Access according to problem in word document

Please see the word document for a description of what the queries should do. Please write and save the queries in access and save the queries with the name being the number of the question it answers. (No 10 and No 31 have already been completed, no need to do them again.) I actually have the answers to these already, I would like to see if quality work will be done to consider future requests for more complicated queries and projects.

Thanks.