Register
Write the sql command to show which tutor needs to be reminded to turn in reports.
155k views
0 votes
Write the sql command to show which tutor needs to be reminded to turn in reports.

User Richard Irons
by
7.8k points

1 Answer

5 votes
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’);
User Jay Lee
by
7.7k points
← Prev Question Next Question →

No related questions found

Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.5m questions

12.2m answers

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Seven basic internal components found in a computer tower
describe an advance in technology that makes life more enjoyable. what discoveries contribute to this technology?
Disadvantages of using animation in advertising? advantages and disadvantages of using animation for education? advantages and disadvantages of using animation in entertainment?
Link Copied!