Question

Write the sql command to show which tutor needs to be reminded to turn in reports.

Answer 1

SELECT TO_CHAR (Tutor Report.Month, 'MONTH') MONTH, Tutor Report.MatchID, Match History.MatchID, MatchHistory.Tutor.ID FROM Tutor Report, MatchID WHERE Tutor Report.MatchID=Match History.MatchID AND NOT (TutorReport.Month=‘JULY’);