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=