Create view PLAYLIST1 as
SELECT p.nome,b.titolo,b.autore
FROM (Playlist p join composizioni c on p.codice=c.lista) join brani b on c.brano=b.codice
ORDER BY p.utente ;
CREATE VIEW playlist2 as
SELECT b.titolo
FROM brani b
WHERE b.titolo in >= (
SELECT cout (*)
FROM playlist p )
Create Trigger MOD_BRANO
AFTER UPDATE [OF codice] ON brano
FOR EACH ROW
BEGIN
UPDATE composizione
SET composizione=:new brano
WHERE composizione =:eek:ld brano
AND
CREATE VIEW playlist2 as SELECT b.Titolo, count(p.Codice)
FROM BRANI b JOIN COMPOSIZIONI c ON b.Codice=b.Brano JOIN PLAYLIST p ON c.Lista=p.Codice
HAV_ING count(p.Codice)>=ALL ( SELECT count(p1.Codice)
FROM PLAYLIST p1 GROUP BY p.Nome )