Tutors Idle Through 2023
Problem
An online tutoring marketplace stores tutors, students, and the sessions taught.
`Student`:
- `student_id` (int), `student_name` (varchar)
`Session`:
- `session_id` (int), `held_on` (date), `fee` (int), `student_id` (int), `tutor_id` (int)
`Tutor`:
- `tutor_id` (int), `tutor_name` (varchar)
Find the tutors who taught **no session at all during 2023**. Return their names ordered alphabetically.
Tables
Example rows — the live problem includes the full dataset.
Student
| student_id | student_name |
|---|---|
| 101 | Hana |
| 102 | Omar |
| 103 | Tess |
Session
| session_id | held_on | fee | student_id | tutor_id |
|---|---|---|---|---|
| 1 | 2023-03-01 | 150 | 101 | 1 |
| 2 | 2023-05-25 | 240 | 102 | 2 |
| 3 | 2022-05-25 | 80 | 101 | 3 |
Tutor
| tutor_id | tutor_name |
|---|---|
| 1 | Devon |
| 2 | Esme |
| 3 | Faris |
Expected output
Your answer should return 1 row with the columns tutor_name.
Starter code (SQL)
SELECT *
FROM Student;Solve this SQL question free
Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.
Solution & explanation
Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.
Sign up free to unlock