Cacher is the code snippet organizer for pro developers

SELECT *
FROM customer_service_actions
where action = 'customer-order'
  and (amount = 0 OR amount is null)
group by customer_id
having count(*) > 1;