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);