Comprehension Passage
Instructor Table
Enrollee Table
How can you find the highest payment made by enrollees under each instructor?
1
SELECT InstructorId, MAX(Payment) FROM Enrollee GROUP BY InstructorId;
2
SELECT InstructorName, MAX(Payment) FROM Enrollee GROUP BY InstructorId;
3
SELECT InstructorId, Payment FROM Enrollee WHERE Payment = (SELECT MAX(Payment) FROM Enrollee);
4
SELECT InstructorId, MAX(Payment) FROM Instructor GROUP BY InstructorId;