DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promo_name = ‘blowout sale’) AND promo_id = (SELECT promo_id FROM promotions WHERE promo_name = ‘everyday low price’) FROM promotions WHERE promo_name = ‘everyday low price’);
DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promotions WHERE promo_name = ‘blowout sale’) OR promo_id = (SELECT promo_id FROM promotions WHERE promo_name = ‘everyday low price’)
DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promotions WHERE promo_name = ‘blowout sale’) OR promo_name = ‘everyday low price’);
DELETE FROM sales WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_name IN = ‘blowout sale’,‘everyday low price’));
