I apologize in advance, but I am a novice when it comes to SQL
I was given the following by my professor, and she isn't answering, so came here for help. Anytime I enter it in, I get error: "Active" in 'where clause'
#Q13
This answer assumes any active tutor may be available to accept a new student:
SELECT Person.LastName, Person.FirstName, Tutor.Status
FROM Person INNER JOIN Tutor ON
Person.PersonID = Tutor.PersonID
WHERE (((Tutor.Status)=’Active’));
This answer assumes a tutor is available only if currently unassigned a student:
SELECT T.TutorID, Person.LastName, Person.FirstName
FROM Person INNER JOIN Tutor AS T
ON Person.PersonID = T.PersonID
WHERE ((
(T.TutorID) IN (
SELECT MH.TutorID
FROM MatchHistory MH
WHERE EndDate IS NOT NULL
) AND
(T.TutorID) NOT IN (
SELECT MH.TutorID
FROM MatchHistory MH
WHERE EndDate IS NULL
)
)
AND ((T.STATUS)= 'Active'));