---

DELIMITER //
CREATE TRIGGER tr_cascade_delete_work
AFTER DELETE ON WORK
FOR EACH ROW
BEGIN
    DELETE FROM TEAM WHERE id = OLD.team;
END //
DELIMITER ;

-- Проверка:
-- Убедитесь, что в WORK есть запись с team=1
DELETE FROM WORK WHERE id = 1;
SELECT * FROM TEAM; -- Команда с id=1 исчезнет