Build a CTE of each customer's total spend (all orders). Then label them: Gold (≥ 10,000), Silver (≥ 4,000), else Bronze. Return name, total_spent, tier for customers who ordered.
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.