Return student_id, amount and fee_status: 'Unpaid' (no paid date), 'Late' (paid after due date), 'On time' (paid on or before due date).
15 rows with columns student_id, amount, fee_status — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 1 | 25000 | On time |
| 2 | 2 | 25000 | Late |
| 3 | 3 | 25000 | Unpaid |
Run your code to see the output here.