select customer_id,count(order_id) as total_orders, sum(amount) as total_spend from orders group by customer_id having count(order_id) >=3 select name, price, case ...