I need help coding SQL on Microsoft Access for these three questions:
1. For any faculty member whose supervisor is in the same department, list the name of the faculty member, the faculty member's department, and the name of his or her supervisor.
2. Which faculty members have the same rank as their supervisor? List the name of the faculty member, the rank of the faculty member, and the name of his or her supervisor.
3. Which students (by ID number) are from Idaho or have registered for section 2717?
Qualified faculty_id course_id date_qualified
1023 ISM 3112 9/1/1985
1023 ISM 3114 9/1/1985
1023 ISM 5003 9/1/1985
1234 ISM 5000 9/1/1995
1234 ISM 5001 9/1/1991
2143 ISM 3112 9/1/1988
2143 ISM 3114 9/1/1998
2319 ISM 5001 9/1/2000
student_id student_first student_last home_town home_state gpa major
12123 Ari Smith Boise ID 2.80 ITM
12345 Drew Schmidt Meridian ID 2.60 ITM
15687 Sydney Wilson Idaho City ID 3.50 HIIM
22255 Sandra Sharda Boise ID 3.80 SCM
23232 Dave Martin Portland OR 3.15 HIIM
23456 Ashleigh George Vancouver WA 3.30 ITM
24654 Sarah Locke Ogden UT 2.75 SCM
course_id course_name
ISM 3112 Systems Analysis
ISM 3113 Systems Design
ISM 3114 Analytics Database Networking
ISM 4212 Junior
ISM 4930
registration student_id section_no
12123 2716
12123 2723
12123 2731
12345 2715
12345 2719
12345 2723
14654 2717
14684 2717
15687 2717
15687 2724
15687 2734
15687 2735
18632 2717
22255 2716
22255 2718
22255 2736
section_no semester course_id Location
2712 I-2006 ISM 3113 MBEB 210
2713 I-2006 ISM 3113 MBEB 123
2714 I-2006 ISM 4212 MBEB 206
2715 I-2006 ISM 4930 MBEB 321
2716 I-2006 ISM 5000 MBEB 210
2717 II-2006 ISM 5000 MBEB 210
2718 I-2007 ISM 5000 MBEB 210
faculty_id faculty_last faculty_first rank
1000 Doe John Full
2143 Birkin Debra Full
2319 Lysne John Associate
2345 Smith Phil Full
4756 Collins Rick Associate
5678 Bottel Dave Management
6547 Lopez Full
8901 Robbins Management
department salary supervisor_id
Administration $150,000.00 2143
Information Systems $85,000.00 1000
Accounting $100,000.00 2345
Management $90,000.00 1000