CREATE TABLE Guide(Codice varchar(4) PRIMARY KEY, 
                   Cognome varchar(30),
                   Nome varchar(30),
                   Eta int, 
                   CostoG decimal(6,2) )
 GO 
INSERT INTO Guide VALUES('pm23','Picasso', 'Maurizio',45,200)
 GO 
INSERT INTO Guide VALUES('fa59','Ferrante', 'Angela',34,170)
 GO 
INSERT INTO Guide VALUES('ca89','Costa', 'Alberto',35,210)
 GO 
INSERT INTO Guide VALUES('bm46','Bacigalupo', 'Maria',38,220)
 GO 
INSERT INTO Guide VALUES('pa34','Parodi', 'Alberto',37,300)
 GO 
INSERT INTO Guide VALUES('bm90','Bottini', 'Mario',44,120)
 GO 
CREATE TABLE Mete(Localita varchar(20), 
                  Comune varchar(10), 
                  Ristoro varchar(1), 
                  Interesse varchar(13) 
                  PRIMARY KEY (Localita,Comune))
 GO 
INSERT INTO Mete VALUES('Lago dei fiori','Genova','n','naturalistico')
 GO 
INSERT INTO Mete VALUES('Forte S. Martino','Genova','s','vario')
 GO 
INSERT INTO Mete VALUES('Punta S. Anna','Chiavari','n','naturalistico')
 GO 
INSERT INTO Mete VALUES('Monte Argentoso','Savona','n','paesaggistico')
 GO 
INSERT INTO Mete VALUES('Colle del lupo','Varazze','s','faunistico')
 GO 
INSERT INTO Mete VALUES('Colle della pietra','Rapallo','s','paesaggistico')
 GO 
INSERT INTO Mete VALUES('Monte Fasce','Genova','s','paesaggistico')
 GO 
INSERT INTO Mete VALUES('Cascate del vento','Ceranesi','n','naturalistico')
 GO 
