BEGIN
SELECT * FROM zanr;

DELETE FROM zanr
WHERE zanrID=delID;

SELECT * FROM zanr;
END

BEGIN
SELECT zanrNimi
FROM zanr
WHERE zanrNimi LIKE concat('%', taht, '%');
END

CALL otsingZanr('o')

BEGIN
SELECT filmNimetus, pikkus
FROM film 
WHERE pikkus < pikk;
END

CALL pikk_väiksem_kui(100)

BEGIN
SELECT * FROM film;
UPDATE film SET pikkus=pikkus*1.1
WHERE filmID=filmID;
SELECT * FROM film;
END

BEGIN
SELECT * FROM zanr;
ALTER TABLE zanr drop COLUMN zanrKirjeldus;
SELECT * from zanr;
END