-- DELETE single table with WHERE condition (no subquery)
DELETE FROM core.reg_subject WHERE code = 'X';
