Title: Available Tutorials and SQL Query
Text: Which tutorials, by name, are available to tutor? Write the SQL query.
TUTOR(TutorID, CertDate, Status)
MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate, StudentID, StartDate, MatchID, TutorID)
100 3000 1/10/2018 1 TutorID 100 101
CertDate Status 1/05/2018 Active 1/05/2018 Temp Stop 1/05/2018 Dropped 5/22/2018 Active 5/22/2018 Active 5/22/2018 Temp Stop 5/22/2018 Active
EndDate
102
103
3001 1/15/2018 3002 2/10/2018 3003 5/28/2018
5/15/2018 3/01/2018
2 3 4
101 102
104
105
106
106
5
103 104 104
3004
6/01/2018
6/15/2018
STUDENT(StudentID, Group, Read)
6 7
3005 6/01/2018 3006 6/01/2018
6/28/2018
StudentID 3000 3001 3002
Group 3 2
Read 2.3 5.6 1.3 3.3 2.7 4.8 7.8
3 1
TUTOR REPORT(MatchID, Month, Hours, Lessons) MatchID Month Hours Lessons 1 6/18 8 4 4 6/18 8 6 5 6/18 4 4 4 7/18 10 5 1 7/18 4 2
3003
3004 3005 3006 3007
2
4
3
4
1.5