Classify Customers into Spend Tiers

Given a customers table with a lifetime_spend column, write a query that assigns each customer a tier: 'Platinum' for spend >= 1000, 'Gold' for spend >= 300, 'Silver' for spend >= 50, and 'Bronze' otherwise. Return customer_id, name, lifetime_spend, and the tier.