For the final exam, return student_id, subject_id, score and result: 'Pass' if score ≥ 40, 'Fail' if below, 'Absent' if the score is missing.
75 rows with columns student_id, subject_id, score, result — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | 1 | 1 | 35 | Fail |
| 2 | 2 | 1 | 72 | Pass |
| 3 | 3 | 1 | 48 | Pass |
Run your code to see the output here.