CREATE TABLE Artista(
Codice INT PRIMARY KEY,
Nome VARCHAR(20),
Cognome VARCHAR(20),
Eta VARCHAR(20)
);
CREATE TABLE Opera(
Codice INT PRIMARY KEY,
Titolo VARCHAR(20),
Valore DECIMAL,
CodArtista INT,
FOREIGN KEY (CodArtista) REFERENCES Artista(Codice)
);
INSERT INTO Artista VALUES(1,'Gianluca','Palmieri',34);
INSERT INTO Artista VALUES(2,'Mario','Rossi',30);
INSERT INTO Artista VALUES(3,'Michele','Verdi',34);
INSERT INTO Artista VALUES(4,'Giuseppe','Rossi',33);
INSERT INTO Artista VALUES(5,'Matteo','Gialli',33);
INSERT INTO Artista VALUES(6,'Vanessa','Gialli',32);
INSERT INTO Artista VALUES(7,'Giuseppe','Verdi',31);
INSERT INTO Artista VALUES(8,'Mario','Rossi',32);
INSERT INTO Opera VALUES(1,'cielo',200,1);
INSERT INTO Opera VALUES(2,'mare',400,1);
INSERT INTO Opera VALUES(3,'terra',100,2);
INSERT INTO Opera VALUES(4,'Giuseppe',40,5);
Q1JFQVRFIFRBQkxFIEFydGlzdGEoCiAgQ29kaWNlIElOVCBQUklNQVJZIEtFWSwKICBOb21lIFZBUkNIQVIoMjApLAogIENvZ25vbWUgVkFSQ0hBUigyMCksCiAgRXRhIFZBUkNIQVIoMjApCik7CgoKQ1JFQVRFIFRBQkxFIE9wZXJhKAogIENvZGljZSBJTlQgUFJJTUFSWSBLRVksCiAgVGl0b2xvIFZBUkNIQVIoMjApLAogIFZhbG9yZSBERUNJTUFMLAogIENvZEFydGlzdGEgSU5ULAogIEZPUkVJR04gS0VZIChDb2RBcnRpc3RhKSBSRUZFUkVOQ0VTIEFydGlzdGEoQ29kaWNlKQogICk7CiAgCiAgSU5TRVJUIElOVE8gQXJ0aXN0YSBWQUxVRVMoMSwnR2lhbmx1Y2EnLCdQYWxtaWVyaScsMzQpOwogIElOU0VSVCBJTlRPIEFydGlzdGEgVkFMVUVTKDIsJ01hcmlvJywnUm9zc2knLDMwKTsKICBJTlNFUlQgSU5UTyBBcnRpc3RhIFZBTFVFUygzLCdNaWNoZWxlJywnVmVyZGknLDM0KTsKICBJTlNFUlQgSU5UTyBBcnRpc3RhIFZBTFVFUyg0LCdHaXVzZXBwZScsJ1Jvc3NpJywzMyk7CiAgSU5TRVJUIElOVE8gQXJ0aXN0YSBWQUxVRVMoNSwnTWF0dGVvJywnR2lhbGxpJywzMyk7CiAgSU5TRVJUIElOVE8gQXJ0aXN0YSBWQUxVRVMoNiwnVmFuZXNzYScsJ0dpYWxsaScsMzIpOwogIElOU0VSVCBJTlRPIEFydGlzdGEgVkFMVUVTKDcsJ0dpdXNlcHBlJywnVmVyZGknLDMxKTsKICBJTlNFUlQgSU5UTyBBcnRpc3RhIFZBTFVFUyg4LCdNYXJpbycsJ1Jvc3NpJywzMik7CiAgCiAgSU5TRVJUIElOVE8gT3BlcmEgVkFMVUVTKDEsJ2NpZWxvJywyMDAsMSk7CiAgSU5TRVJUIElOVE8gT3BlcmEgVkFMVUVTKDIsJ21hcmUnLDQwMCwxKTsKICBJTlNFUlQgSU5UTyBPcGVyYSBWQUxVRVMoMywndGVycmEnLDEwMCwyKTsKICBJTlNFUlQgSU5UTyBPcGVyYSBWQUxVRVMoNCwnR2l1c2VwcGUnLDQwLDUpOwogIAo=