Compound Conditions Can Use AND, OR, NOT

   SELECT * FROM order_item WHERE order_id = 5;

Now we want to delete the radio items (item id 1):

   DELETE FROM order_item WHERE order_id = 5 AND 
                                item_id = 1;