mahir_data
easyBoost · basics

Classify e-wallet balances into tiers

Boost wants to tag each e-wallet with a loyalty tier based on its current balance: Platinum for RM 500 or more, Gold for RM 100 up to (but not including) RM 500, and Standard for anything below RM 100.

Return user_name, balance, and tier.

Schema

wallets
idINT
user_nameTEXT
balanceNUMERIC

Example input

wallets