Classify insurance policies into tiers
AIA wants to tag each policy with a tier based on its coverage amount: Elite for RM 1,000,000 or more, Standard for RM 200,000 up to (but not including) RM 1,000,000, and Basic for anything below that.
Return policyholder, coverage_amount, and tier.
Schema
| id | INT |
| policyholder | TEXT |
| annual_premium | NUMERIC |
| coverage_amount | NUMERIC |
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.
The interviewer's next question
AIA also wants a headline number for each tier: how many policies fall into 'Elite', 'Standard' and 'Basic'? Return tier and policy_count, ordered from the highest-coverage tier down to the lowest.
Solving follow-ups — the questions an interviewer actually asks next — unlocks with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
AIA is splitting the bottom tier further: add a fourth label, Minimal, for anything under RM 100,000. 'Basic' now means RM 100,000 up to (but not including) RM 200,000. Elite and Standard are unchanged.
Solving follow-ups — the questions an interviewer actually asks next — unlocks with a Basic plan.
See Basic plansRM 25/mo · cancel anytime