-- Delete products produced by a manufacturer.
-- Here the manufacturer is specified
-- as a literal.
--
DELETE FROM product
WHERE manufacturer_id = 19985678
