[Assistant]

Код:

DELETE FROM
  bron
WHERE
  id_razm IN (SELECT
                razm.id_razm
              FROM
                razm, bron
              WHERE
                razm.id_razm = bron.id_razm AND
                zaezd < CAST(CURRENT_TIMESTAMP as DATE));

скобки пропустили и слово CAST