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 ...
/*Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.