TUTOR (TutorlD, CertDate, Status) MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate) TutorID CertDate Status 1/05/2015 Active 1/05/2015 Temp Stop 100 MatchID TutorID StudentID StartDate...


Write an SQL query to list the Read scores of students who were ever taught by tutors whose status is Dropped.


TUTOR (TutorlD, CertDate, Status)<br>MATCH HISTORY (MatchID, TutorID, StudentID,<br>StartDate, EndDate)<br>TutorID<br>CertDate<br>Status<br>1/05/2015 Active<br>1/05/2015 Temp Stop<br>100<br>MatchID<br>TutorID<br>StudentID<br>StartDate<br>EndDate<br>101<br>3000 1/10/2015<br>1<br>100<br>102<br>1/05/2015 Dropped<br>103<br>5/22/2015 Active<br>3001 1/15/2015<br>101<br>5/15/2015<br>104<br>5/22/2015 Active<br>3<br>102<br>3002 2/10/2015<br>3/01/2015<br>105<br>5/22/2015 Temp Stop<br>4<br>106<br>3003 5/28/2015<br>106<br>5/22/2015 Active<br>3004 6/01/2015<br>3005 6/01/2015<br>5<br>103<br>6/15/2015<br>STUDENT (StudentID, Read)<br>6<br>104<br>6/28/2015<br>StudentID<br>Read<br>7<br>104<br>3006 | 6/01/2015<br>3000<br>2.3<br>3001<br>5.6<br>3002<br>1.3<br>TUTOR REPORT (MatchID, Month, Hours, Lessons)<br>3003<br>3.3<br>MatchID<br>Month<br>Hours<br>Lessons<br>3004<br>2.7<br>6/15<br>8<br>4<br>3005<br>4.8<br>4<br>6/15<br>6<br>3006<br>7.8<br>5<br>6/15<br>4<br>4<br>3007<br>1.5<br>4| 7/15<br>10<br>5<br>1<br>7/15<br>4<br>2<br>20 JALaite SOLaueri<br>voSven he fellowine ovestiong<br>- 26 JAbora de vou think etudont and uto information suab<br>9:51 PM<br>5/1/2021<br>

Extracted text: TUTOR (TutorlD, CertDate, Status) MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate) TutorID CertDate Status 1/05/2015 Active 1/05/2015 Temp Stop 100 MatchID TutorID StudentID StartDate EndDate 101 3000 1/10/2015 1 100 102 1/05/2015 Dropped 103 5/22/2015 Active 3001 1/15/2015 101 5/15/2015 104 5/22/2015 Active 3 102 3002 2/10/2015 3/01/2015 105 5/22/2015 Temp Stop 4 106 3003 5/28/2015 106 5/22/2015 Active 3004 6/01/2015 3005 6/01/2015 5 103 6/15/2015 STUDENT (StudentID, Read) 6 104 6/28/2015 StudentID Read 7 104 3006 | 6/01/2015 3000 2.3 3001 5.6 3002 1.3 TUTOR REPORT (MatchID, Month, Hours, Lessons) 3003 3.3 MatchID Month Hours Lessons 3004 2.7 6/15 8 4 3005 4.8 4 6/15 6 3006 7.8 5 6/15 4 4 3007 1.5 4| 7/15 10 5 1 7/15 4 2 20 JALaite SOLaueri voSven he fellowine ovestiong - 26 JAbora de vou think etudont and uto information suab 9:51 PM 5/1/2021

Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here