Abwärtskompatibilität 3
CREATE VIEW hohes_gehalt AS
SELECT * FROM gehalt WHERE gehalt > 3500;
UPDATE gehalt g
SET summe = 1.1 * summe
WHERE g.ano = (SELECT a.ano
FROM angestellte a WHERE a.name = 'Theresa');
COMMIT;