mediumTenaga Nasional · basics
Label TNB bills as on-time, late, or unpaid
TNB wants a status label for every electricity bill:
- Unpaid if it hasn't been paid yet (paid_date is missing)
- Paid on time if it was paid on or before the due date
- Paid late if it was paid after the due date
Return customer, amount, and status.
Schema
▸bills
| id | INT |
| customer | TEXT |
| amount | NUMERIC |
| due_date | DATE |
| paid_date | DATE |
Example input
▸bills
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.