-- Delete products produced by a manufacturer.
-- The manufacturer id is determine by a nested
-- select using the manufacturer name to get the
-- manufacturer id.
-- The nested select replaces the manufacturer
-- id literal in delete-by-manufacturer-id.sql.
--
DELETE FROM product
WHERE manufacturer_id = (
  SELECT manufacturer_id
  FROM manufacturer
  WHERE "NAME" = 'Happy End Searching'
)
