Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Microsoft Access Query Find all instructors scheduled to teach in at least two semesters. Output a table consisting of three columns: FirstName, LastName, Number of
Microsoft Access Query
Find all instructors scheduled to teach in at least two semesters. Output a table consisting of three columns: FirstName, LastName, Number of Courses.
InstrId | FirstName | LastName | DeptId |
---|---|---|---|
001 | John | von Neumann | Math |
002 | Richard | Feynman | Phys |
003 | Donald | Knuth | CS |
004 | Alan | Turing | CS |
CourseId | Term | InstrId |
---|---|---|
CS 200 | Fall 2016 | 003 |
CS 200 | Fall 2017 | 003 |
CS 300 | Spring 2017 | 003 |
CS 400 | Fall 2016 | 004 |
CS 400 | Fall 2017 | 004 |
Math 200 | Fall 2016 | 001 |
Math 200 | Spring 2017 | 004 |
Math 200 | Fall 2017 | 001 |
Phys 400 | Spring 2017 | 002 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started