2084-drop-type-1-orders-for-customers-with-type-0-orders.sql

# Write your MySQL query statement below
SELECT * FROM Orders
WHERE (customer_id, order_type) 
IN (SELECT customer_id, MIN(order_type) 
    FROM Orders 
    GROUP BY customer_id);