I have a sample source table here and currently, it is returning multiple records due to multiple tutors.
I want to select only the tutor_name if the exam_date is between the effective date and the next record's effective date. Sample desired output:
