Please help me answer all this SQL questions using Microsoft access.

Query 11. Using a subquery, list the courses (by name and ID) that were not offered in semester I-2007

Query 12. What is the maximum salary in each department?

Query 13 Which faculty in the Information systems department are not qualified to teach ISM 4212

Query14 Which faculty (by name) are qualified to teach ISM 3114 and have a salary greater than the average of all faculty?

Class Scheduling DB qualified date qualified 9/1/1985 1023 ISM 3112 1023 ISM 3114 1023 ISM 5003 1234 ISM 5000 1234 ISM 5001 2143 ISM 3112 2143 ISM 3114 2319 ISM 5001 student id student_first student last home_town home state gpa major class 1985 9/1/1995 9/1/1991 9/1/1988 Boise Meridian Idaho City Boise Portland Vancouver 0 Junior 12123 Ari 12345 Drew 15687 Sydney 22255 Sandra 23232 Dave 23456 Ashleigh George 24654 Sarah Smith Schmidt Wilson Sharda Martin 2.80 ITMM 2.60 ITM Freshman 3.50 HIIM Freshman 3.80 SCM Junior 3.15 HIIM Sophomore 3.30 ITMM 2.75 SCM Junior course id ISM 3112 ISM 3113 ISM 3114 ISM 4212 ISM 4930 Systems Analysis Systems Design Analytics Database 2000 WA Junior Locke stration semester course id Location faculty faculty id faculty_last faculty_first rank 2712 I-2006 2713 -2006 2714 1-2006 2715 1-2006 2716 1-2006 2717 I-2006 ISM 5000 MBEB 210 2718 1-2007 ISM ISM 3113 MBEB 210 ISM 3113 MBEB 123 ISM 4212 MBEB 206 ISM 4930 MBEB 321 ISM 5000 MBEB 210 12123 $150,000.00 Information Systems $85,000.00 $100,000.00 90,000.00 85,000.00 AssociateInformation Systems 80,000.00 100,000.00 90,000.00 1000 Doe Debra 2143 Birkin 2319 Lysne 2345 Smith 4756 Collins 5678 Bottel 654 Lopez 8901 Robbins 1000 6547 1000 2345 Full Full 5000 MBEB 210 5687 Full 1000 22255 Associate Ma 2345