Shipped or delivered orders worth over RM 100
Find orders that are either shipped or delivered, AND worth more than RM 100.
Return customer and total.
Schema
▸orders
| id | INT |
| customer | TEXT |
| total | NUMERIC |
| status | TEXT |
Example input
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.