-- when employee_id % 2 = 1 AND name not like 'M%' THEN salary -- where customer_id In (select customer_id from orders where product_name = 'A') -- and customer_id in (select customer_id from orders ...