Question: Problems and are based on Figure 7-17. This problem set continues from Chapter 6, Problems and Exercises 6-45 through 6-53, which were based on Figure

Problems and are based on Figure 7-17. This problem set continues from Chapter 6, Problems and Exercises 6-45 through 6-53, which were based on Figure 6-12. FIGURE 7-17 Adult literacy program (for Problems and Exercises 7-31-7-41) TUTOR TutorlD, CertDate, Status) MATCH HISTORY (MatchlD, TutorID, StudentID StartDate, EndDate) TutorlDCertDate Status 100 1/05/2015 Active 101 1/05/2015 Temp Stop 102 1/05/2015 Dropped 103 5/22/2015 Active 104 5/22/2015 Active 105 5/22/2015 Temp Stop 106 5/22/2015 Active TutorD StudentiD StartDate End Date 100 3000 1/10/2015 101 102 106 2 3001 1/15/2015 5/15/2015 3002 2/10/2015 3/01/2015 3003 5/28/2015 5 6 7 103 104 104 3004 6/01/2015 6/15/2015 3005 6/01/2015 6/28/2015 3006 6/01/2015 STUDENT (StudentID, Read) StudentiD Read 30002.3 3001 5.6 3002 1.3 3003 3.3 30042.7 3005 4.8 30067.8 3007 1.5 TUTOR REPORT MatchID, Month, Hours, Lessons) MatchiD Month Hours Lessons 1 6/15 4 6/15 5 6/15 4 7/15 1 7/15 6 10 2 Which tutors, by name, are available to tutor? Write the SQL command
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
