

------------------------------------------------------------------------------------------------
--               P O P O L A M E N T O      D E L      D A T A      B A S E                   --
------------------------------------------------------------------------------------------------
set datestyle to US;--serve per mettere le date nel formato mm-gg-yyyyy

INSERT INTO studenti VALUES( 1,'BENNATO'   , 'Nicola'    , 'M', '07-10-1984', 70, 171);
INSERT INTO studenti VALUES( 2,'DEROSSI'   , 'Alessio'   , 'M', '06-12-1983', 75, 162);
INSERT INTO studenti VALUES( 3,'DACCI'     , 'Diego'     , 'M', '11-10-1984', 78, 173);
INSERT INTO studenti VALUES( 4,'DORIA'     , 'Luca'      , 'M', '12-02-1983', 72, 168);
INSERT INTO studenti VALUES( 5,'FAZIO'     , 'Laila'     , 'F', '11-05-1981', 60, 175);
INSERT INTO studenti VALUES( 6,'GIORDANI'  , 'Jenny'     , 'F', '08-09-1984', 74, 183);
INSERT INTO studenti VALUES( 7,'GRAVELLI'  , 'Stefania'  , 'F', '09-07-1984', 73, 190);
INSERT INTO studenti VALUES( 8,'ITALIANI'  , 'Matteo'    , 'M', '07-01-1984', 65, 176);
INSERT INTO studenti VALUES( 9,'LANDINI'   , 'Manuele'   , 'M', '08-12-1983', 78, 177);
INSERT INTO studenti VALUES(10,'MANFREDI'  , 'Carlo'     , 'M', '01-06-1983', 71, 162);
INSERT INTO studenti VALUES(11,'MANTOVANI' , 'Mirko'     , 'M', '03-03-1984', 62, 187);
INSERT INTO studenti VALUES(12,'MODENESI'  , 'Marco'     , 'M', '06-01-1984', 74, 174);
INSERT INTO studenti VALUES(13,'MORA'      , 'Luigi'     , 'M', '06-04-1983', 77, 189);
INSERT INTO studenti VALUES(14,'MORATI'    , 'Luca'      , 'M', '08-08-1984', 68, 186);
INSERT INTO studenti VALUES(15,'PARMIGIANI', 'Alessandro', 'M', '02-03-1983', 73, 185);
INSERT INTO studenti VALUES(16,'SALVARANI' , 'Sara'      , 'F', '09-06-1984', 84, 172);
INSERT INTO studenti VALUES(17,'SERVENTI'  , 'Loris'     , 'M', '06-11-1984', 77, 186);
INSERT INTO studenti VALUES(18,'SICURI'    , 'Luigi'     , 'M', '02-06-1983', 85, 178);
INSERT INTO studenti VALUES(19,'SIROCCHI'  , 'Davide'    , 'M', '11-08-1984', 84, 189);
INSERT INTO studenti VALUES(20,'TRAMELLI'  , 'Mirco'     , 'M', '12-04-1984', 73, 176);


INSERT INTO insegnanti VALUES( 1,'BURANI'   , 'Annamaria'  , 'F', '11-04-1964');
INSERT INTO insegnanti VALUES( 2,'BACCHINI' , 'Luciana'    , 'F', '07-06-1973');
INSERT INTO insegnanti VALUES( 3,'ZANI'     , 'Nella'      , 'F', '07-12-1956');
INSERT INTO insegnanti VALUES( 4,'SIRANI'   , 'Silva'      , 'F', '11-06-1949');
INSERT INTO insegnanti VALUES( 5,'FERRARI'  , 'Luciana'    , 'F', '12-09-1961');
INSERT INTO insegnanti VALUES( 6,'BELLI'    , 'Laura'      , 'F', '11-08-1952');
INSERT INTO insegnanti VALUES( 7,'CARONNA'  , 'Gianfranco' , 'M', '07-11-1963');
INSERT INTO insegnanti VALUES( 8,'CAVANNA'  , 'Roberto'    , 'M', '01-10-1978');
INSERT INTO insegnanti VALUES( 9,'SACCHI'   , 'Fabrizio'   , 'M', '09-02-1967');
INSERT INTO insegnanti VALUES(10,'DALL''ARE', 'Marco'      , 'M', '10-02-1958');
INSERT INTO insegnanti VALUES(11,'PAOLI'    , 'Giammarco'  , 'M', '08-01-1966');
INSERT INTO insegnanti VALUES(12,'ZANONI'   , 'Roberto'    , 'M', '02-04-1959');

INSERT INTO materie VALUES('REL', 'Religione'              , 1,  1 );
INSERT INTO materie VALUES('ITA', 'Italiano'               , 3,  2 );
INSERT INTO materie VALUES('STO', 'Storia'                 , 2,  2 );
INSERT INTO materie VALUES('EDF', 'Educazione fisica'      , 2,  3 );
INSERT INTO materie VALUES('ING', 'Inglese'                , 3,  4 );
INSERT INTO materie VALUES('MAT', 'Matematica'             , 2,  5 );
INSERT INTO materie VALUES('STA', 'Statistica'             , 2,  6 );
INSERT INTO materie VALUES('ELE', 'Elettronica'            , 3,  7 );
INSERT INTO materie VALUES('INF', 'Informatica'            , 3,  8 );
INSERT INTO materie VALUES('SIS', 'Sistemi'                , 3,  9 );
INSERT INTO materie VALUES('MAL', 'Matematica laboratorio' , 2, 11 );
INSERT INTO materie VALUES('STL', 'Statistica laboratorio' , 1, 11 );
INSERT INTO materie VALUES('ELL', 'Elettronica laboratorio', 3, 12 );
INSERT INTO materie VALUES('INL', 'Informatica laboratorio', 3, 10 );
INSERT INTO materie VALUES('SIL', 'Sistemi laboratorio'    , 3, 10 );


INSERT INTO verifiche VALUES('ITA',  1, '07-17-2004', 5 );
INSERT INTO verifiche VALUES('ITA',  5, '08-18-2004', 5 );
INSERT INTO verifiche VALUES('ITA',  2, '07-21-2004', 6 );
INSERT INTO verifiche VALUES('ITA',  3, '07-21-2004', 7 );
INSERT INTO verifiche VALUES('ITA',  4, '09-23-2004', 1 );
INSERT INTO verifiche VALUES('ITA',  5, '09-15-2004', 2 );
INSERT INTO verifiche VALUES('ITA',  6, '09-30-2004', 4 );
INSERT INTO verifiche VALUES('ITA',  7, '09-17-2004', 8 );
INSERT INTO verifiche VALUES('ITA',  8, '07-25-2004', 9 );
INSERT INTO verifiche VALUES('ITA',  9, '12-15-2004',10  );
INSERT INTO verifiche VALUES('ITA', 10, '12-01-2004',10  );
INSERT INTO verifiche VALUES('ITA', 11, '12-13-2004', 4 );
INSERT INTO verifiche VALUES('ITA', 12, '07-14-2004', 3 );
INSERT INTO verifiche VALUES('ITA', 13, '12-15-2004', 6 );
INSERT INTO verifiche VALUES('ITA', 14, '12-11-2004', 7 );
INSERT INTO verifiche VALUES('ITA', 15, '12-22-2004', 8 );
INSERT INTO verifiche VALUES('ITA', 16, '10-13-2004', 9 );
INSERT INTO verifiche VALUES('ITA', 17, '10-24-2004',10  );
INSERT INTO verifiche VALUES('ITA', 19, '10-15-2004', 2 );
INSERT INTO verifiche VALUES('ITA', 20, '10-25-2004', 1 );
INSERT INTO verifiche VALUES('ITA',  1, '10-12-2004', 3 );
INSERT INTO verifiche VALUES('ITA',  2, '10-21-2004', 4 );
INSERT INTO verifiche VALUES('ITA',  3, '02-23-2004', 5 );
INSERT INTO verifiche VALUES('ITA',  4, '02-21-2004', 6 );
INSERT INTO verifiche VALUES('ITA',  5, '02-04-2004', 5 );
INSERT INTO verifiche VALUES('ITA',  6, '02-01-2004', 6 );
INSERT INTO verifiche VALUES('ITA',  6, '01-05-2004', 6 );
INSERT INTO verifiche VALUES('ITA',  7, '01-02-2004', 7 );
INSERT INTO verifiche VALUES('ITA',  6, '03-02-2004', 6 );
INSERT INTO verifiche VALUES('ITA',  7, '03-01-2004', 7 );
INSERT INTO verifiche VALUES('ITA',  8, '03-03-2004', 8 );
INSERT INTO verifiche VALUES('ITA',  9, '03-04-2004', 6 );

INSERT INTO verifiche VALUES('STO',  1, '07-21-2004', 4 );
INSERT INTO verifiche VALUES('STO',  5, '07-01-2004', 6 );
INSERT INTO verifiche VALUES('STO',  2, '07-22-2004', 6 );
INSERT INTO verifiche VALUES('STO',  3, '07-01-2004', 7 );
INSERT INTO verifiche VALUES('STO',  4, '09-03-2004', 4 );
INSERT INTO verifiche VALUES('STO',  5, '09-01-2004', 5 );
INSERT INTO verifiche VALUES('STO',  6, '09-23-2004', 4 );
INSERT INTO verifiche VALUES('STO',  7, '09-24-2004', 8 );
INSERT INTO verifiche VALUES('STO',  8, '07-25-2004', 8 );
INSERT INTO verifiche VALUES('STO',  9, '12-15-2004', 8 );
INSERT INTO verifiche VALUES('STO', 10, '12-22-2004', 7 );
INSERT INTO verifiche VALUES('STO', 11, '12-13-2004',10 );
INSERT INTO verifiche VALUES('STO', 18, '07-14-2004', 4 );
INSERT INTO verifiche VALUES('STO', 16, '12-25-2004', 2 );
INSERT INTO verifiche VALUES('STO', 14, '12-11-2004', 3 );
INSERT INTO verifiche VALUES('STO', 17, '12-22-2004', 7 );
INSERT INTO verifiche VALUES('STO', 16, '06-13-2004', 8 );
INSERT INTO verifiche VALUES('STO', 17, '06-24-2004', 9  );
INSERT INTO verifiche VALUES('STO', 19, '06-15-2004', 4 );
INSERT INTO verifiche VALUES('STO', 20, '06-25-2004', 3 );
INSERT INTO verifiche VALUES('STO',  1, '06-22-2004', 4 );
INSERT INTO verifiche VALUES('STO',  2, '06-11-2004', 6 );
INSERT INTO verifiche VALUES('STO',  3, '12-13-2004', 4 );
INSERT INTO verifiche VALUES('STO',  4, '01-21-2004', 5 );
INSERT INTO verifiche VALUES('STO',  5, '02-14-2004', 7 );
INSERT INTO verifiche VALUES('STO',  6, '01-21-2004', 6 );
INSERT INTO verifiche VALUES('STO',  6, '01-15-2004', 5 );
INSERT INTO verifiche VALUES('STO',  7, '02-02-2004', 7 );
INSERT INTO verifiche VALUES('STO',  6, '02-22-2004', 6 );
INSERT INTO verifiche VALUES('STO',  7, '02-11-2004', 7 );
INSERT INTO verifiche VALUES('STO',  8, '03-23-2004', 8 );
INSERT INTO verifiche VALUES('STO',  9, '03-14-2004', 6 );

INSERT INTO verifiche VALUES('MAT',  1, '07-01-2004', 2 );
INSERT INTO verifiche VALUES('MAT',  5, '08-01-2004', 3 );
INSERT INTO verifiche VALUES('MAT',  2, '07-02-2004', 6 );
INSERT INTO verifiche VALUES('MAT',  3, '07-01-2004', 4 );
INSERT INTO verifiche VALUES('MAT',  6, '08-03-2004', 7 );
INSERT INTO verifiche VALUES('MAT',  5, '09-01-2004', 8 );
INSERT INTO verifiche VALUES('MAT',  6, '09-03-2004', 5 );
INSERT INTO verifiche VALUES('MAT',  7, '09-04-2004', 4 );
INSERT INTO verifiche VALUES('MAT', 12, '07-05-2004', 7 );
INSERT INTO verifiche VALUES('MAT',  9, '12-05-2004', 9  );
INSERT INTO verifiche VALUES('MAT', 10, '12-02-2004', 8  );
INSERT INTO verifiche VALUES('MAT', 11, '12-03-2004',10 );
INSERT INTO verifiche VALUES('MAT', 12, '07-04-2004', 6 );
INSERT INTO verifiche VALUES('MAT', 13, '12-05-2004', 4 );
INSERT INTO verifiche VALUES('MAT', 14, '12-01-2004', 3 );
INSERT INTO verifiche VALUES('MAT', 15, '12-02-2004', 5 );
INSERT INTO verifiche VALUES('MAT', 16, '06-03-2004', 5 );
INSERT INTO verifiche VALUES('MAT', 17, '06-04-2004', 5  );
INSERT INTO verifiche VALUES('MAT', 19, '06-05-2004', 8 );
INSERT INTO verifiche VALUES('MAT', 20, '06-05-2004', 8 );
INSERT INTO verifiche VALUES('MAT',  1, '06-02-2004', 9 );
INSERT INTO verifiche VALUES('MAT',  2, '06-01-2004', 7 );
INSERT INTO verifiche VALUES('MAT',  3, '12-03-2004', 6 );
INSERT INTO verifiche VALUES('MAT',  4, '02-01-2004', 5 );
INSERT INTO verifiche VALUES('MAT',  5, '02-04-2004', 6 );
INSERT INTO verifiche VALUES('MAT',  6, '02-01-2004', 5 );
INSERT INTO verifiche VALUES('MAT',  6, '11-05-2004', 4 );
INSERT INTO verifiche VALUES('MAT',  7, '02-02-2004', 5 );
INSERT INTO verifiche VALUES('MAT',  6, '03-02-2004', 3 );
INSERT INTO verifiche VALUES('MAT',  7, '03-01-2004', 8 );
INSERT INTO verifiche VALUES('MAT',  8, '03-03-2004', 5 );
INSERT INTO verifiche VALUES('MAT',  9, '03-04-2004', 7 );

INSERT INTO verifiche VALUES('ING',  1, '08-01-2004', 7);
INSERT INTO verifiche VALUES('ING',  5, '09-01-2004', 5 );
INSERT INTO verifiche VALUES('ING',  2, '08-02-2004', 4 );
INSERT INTO verifiche VALUES('ING',  3, '09-01-2004', 7 );
INSERT INTO verifiche VALUES('ING',  4, '09-03-2004', 9 );
INSERT INTO verifiche VALUES('ING',  5, '09-04-2004', 2 );
INSERT INTO verifiche VALUES('ING',  6, '09-05-2004', 7 );
INSERT INTO verifiche VALUES('ING',  7, '09-06-2004', 4 );
INSERT INTO verifiche VALUES('ING',  8, '07-07-2004', 6 );
INSERT INTO verifiche VALUES('ING',  9, '03-07-2004', 5 );
INSERT INTO verifiche VALUES('ING', 10, '03-12-2004', 4 );
INSERT INTO verifiche VALUES('ING', 11, '04-13-2004', 8 );
INSERT INTO verifiche VALUES('ING', 18, '05-24-2004', 5 );
INSERT INTO verifiche VALUES('ING', 16, '06-15-2004', 4 );
INSERT INTO verifiche VALUES('ING', 14, '07-11-2004', 3 );
INSERT INTO verifiche VALUES('ING', 17, '05-12-2004', 5 );
INSERT INTO verifiche VALUES('ING', 16, '07-13-2004', 5 );
INSERT INTO verifiche VALUES('ING', 17, '06-14-2004', 7  );
INSERT INTO verifiche VALUES('ING', 19, '08-15-2004', 6 );
INSERT INTO verifiche VALUES('ING', 20, '09-15-2004', 7 );
INSERT INTO verifiche VALUES('ING',  1, '09-22-2004', 8 );
INSERT INTO verifiche VALUES('ING',  2, '10-21-2004', 6 );
INSERT INTO verifiche VALUES('ING',  3, '12-23-2004', 7 );
INSERT INTO verifiche VALUES('ING',  4, '12-21-2004', 6 );
INSERT INTO verifiche VALUES('ING',  5, '02-24-2004', 5 );
INSERT INTO verifiche VALUES('ING',  6, '02-21-2004', 8 );
INSERT INTO verifiche VALUES('ING',  6, '11-25-2004', 7 );
INSERT INTO verifiche VALUES('ING',  7, '02-12-2004', 5 );
INSERT INTO verifiche VALUES('ING',  6, '03-22-2004', 4 );
INSERT INTO verifiche VALUES('ING',  7, '03-21-2004', 5 );
INSERT INTO verifiche VALUES('ING',  8, '03-03-2004', 6 );
INSERT INTO verifiche VALUES('ING',  9, '03-04-2004', 4 );

INSERT INTO verifiche VALUES('STA',  1, '07-01-2004', 6 );
INSERT INTO verifiche VALUES('STA',  5, '09-01-2004', 7 );
INSERT INTO verifiche VALUES('STA',  2, '08-02-2004', 5 );
INSERT INTO verifiche VALUES('STA',  3, '07-01-2004', 6 );
INSERT INTO verifiche VALUES('STA',  4, '09-03-2004', 4 );
INSERT INTO verifiche VALUES('STA',  5, '03-01-2004', 8 );
INSERT INTO verifiche VALUES('STA',  6, '09-03-2004', 9 );
INSERT INTO verifiche VALUES('STA',  7, '03-04-2004', 8 );
INSERT INTO verifiche VALUES('STA',  8, '03-05-2004', 8 );
INSERT INTO verifiche VALUES('STA',  9, '12-05-2004', 9 );
INSERT INTO verifiche VALUES('STA', 10, '09-02-2004', 7 );
INSERT INTO verifiche VALUES('STA', 11, '03-03-2004', 6 );
INSERT INTO verifiche VALUES('STA', 12, '03-04-2004', 8 );
INSERT INTO verifiche VALUES('STA', 13, '03-05-2004', 5 );
INSERT INTO verifiche VALUES('STA', 14, '12-01-2004', 3 );
INSERT INTO verifiche VALUES('STA', 15, '12-02-2004',10 );
INSERT INTO verifiche VALUES('STA', 16, '03-03-2004', 7 );
INSERT INTO verifiche VALUES('STA', 17, '03-04-2004',10 );
INSERT INTO verifiche VALUES('STA', 19, '03-05-2004', 2 );
INSERT INTO verifiche VALUES('STA', 20, '03-05-2004', 1 );
INSERT INTO verifiche VALUES('STA',  1, '03-02-2004', 3 );
INSERT INTO verifiche VALUES('STA',  2, '03-01-2004', 4 );
INSERT INTO verifiche VALUES('STA',  3, '03-03-2004', 5 );
INSERT INTO verifiche VALUES('STA',  4, '09-01-2004', 6 );
INSERT INTO verifiche VALUES('STA',  5, '09-04-2004', 6 );
INSERT INTO verifiche VALUES('STA',  6, '09-01-2004', 7 );
INSERT INTO verifiche VALUES('STA',  6, '09-05-2004', 6 );
INSERT INTO verifiche VALUES('STA',  7, '09-02-2004', 8 );
INSERT INTO verifiche VALUES('STA',  6, '09-02-2004', 6 );
INSERT INTO verifiche VALUES('STA',  7, '09-01-2004', 5 );
INSERT INTO verifiche VALUES('STA',  8, '09-03-2004', 7 );
INSERT INTO verifiche VALUES('STA',  9, '09-04-2004', 4 );

INSERT INTO verifiche VALUES('ELE',  1, '07-01-2004', 3 );
INSERT INTO verifiche VALUES('ELE',  5, '07-01-2004', 6 );
INSERT INTO verifiche VALUES('ELE',  2, '07-02-2004', 6 );
INSERT INTO verifiche VALUES('ELE',  3, '07-01-2004', 7 );
INSERT INTO verifiche VALUES('ELE',  4, '09-03-2004', 4 );
INSERT INTO verifiche VALUES('ELE',  5, '09-01-2004', 5 );
INSERT INTO verifiche VALUES('ELE',  6, '09-03-2004', 5 );
INSERT INTO verifiche VALUES('ELE',  7, '09-04-2004', 8 );
INSERT INTO verifiche VALUES('ELE',  8, '07-05-2004', 7 );
INSERT INTO verifiche VALUES('ELE',  9, '12-05-2004', 8 );
INSERT INTO verifiche VALUES('ELE', 10, '12-02-2004', 9 );
INSERT INTO verifiche VALUES('ELE', 11, '12-03-2004',10 );
INSERT INTO verifiche VALUES('ELE', 18, '07-04-2004', 4 );
INSERT INTO verifiche VALUES('ELE', 16, '07-05-2004', 4 );
INSERT INTO verifiche VALUES('ELE', 14, '12-01-2004', 3 );
INSERT INTO verifiche VALUES('ELE', 17, '12-02-2004', 8 );
INSERT INTO verifiche VALUES('ELE', 16, '07-03-2004', 5 );
INSERT INTO verifiche VALUES('ELE', 17, '07-04-2004', 9  );
INSERT INTO verifiche VALUES('ELE', 19, '07-05-2004', 6 );
INSERT INTO verifiche VALUES('ELE', 20, '07-05-2004', 9 );
INSERT INTO verifiche VALUES('ELE',  1, '07-02-2004', 6 );
INSERT INTO verifiche VALUES('ELE',  2, '07-01-2004', 6 );
INSERT INTO verifiche VALUES('ELE',  3, '07-03-2004', 4 );
INSERT INTO verifiche VALUES('ELE',  4, '07-01-2004', 5 );
INSERT INTO verifiche VALUES('ELE',  5, '12-04-2004', 7 );
INSERT INTO verifiche VALUES('ELE',  6, '12-01-2004', 7 );
INSERT INTO verifiche VALUES('ELE',  6, '12-05-2004', 5 );
INSERT INTO verifiche VALUES('ELE',  7, '12-02-2004', 7 );
INSERT INTO verifiche VALUES('ELE',  6, '12-02-2004', 8 );
INSERT INTO verifiche VALUES('ELE',  7, '12-01-2004', 7 );
INSERT INTO verifiche VALUES('ELE',  8, '12-03-2004', 8 );
INSERT INTO verifiche VALUES('ELE',  9, '12-04-2004', 6 );

INSERT INTO verifiche VALUES('INF',  1, '07-01-2004', 8 );
INSERT INTO verifiche VALUES('INF',  5, '09-01-2004', 7 );
INSERT INTO verifiche VALUES('INF',  2, '08-02-2004', 7 );
INSERT INTO verifiche VALUES('INF',  3, '07-01-2004', 8 );
INSERT INTO verifiche VALUES('INF',  4, '09-03-2004', 4 );
INSERT INTO verifiche VALUES('INF',  5, '10-01-2004', 8 );
INSERT INTO verifiche VALUES('INF',  6, '09-03-2004', 9 );
INSERT INTO verifiche VALUES('INF',  7, '08-04-2004', 9 );
INSERT INTO verifiche VALUES('INF',  8, '08-05-2004', 5 );
INSERT INTO verifiche VALUES('INF',  9, '12-05-2004', 4 );
INSERT INTO verifiche VALUES('INF', 10, '08-02-2004', 7 );
INSERT INTO verifiche VALUES('INF', 11, '07-03-2004', 6 );
INSERT INTO verifiche VALUES('INF', 12, '07-04-2004', 8 );
INSERT INTO verifiche VALUES('INF', 13, '12-05-2004', 5 );
INSERT INTO verifiche VALUES('INF', 14, '12-01-2004', 3 );
INSERT INTO verifiche VALUES('INF', 15, '12-02-2004', 8 );
INSERT INTO verifiche VALUES('INF', 16, '08-03-2004', 5 );
INSERT INTO verifiche VALUES('INF', 17, '08-04-2004',10 );
INSERT INTO verifiche VALUES('INF', 19, '08-05-2004', 2 );
INSERT INTO verifiche VALUES('INF', 20, '08-05-2004', 4 );
INSERT INTO verifiche VALUES('INF',  1, '08-02-2004', 3 );
INSERT INTO verifiche VALUES('INF',  2, '08-01-2004', 3 );
INSERT INTO verifiche VALUES('INF',  3, '08-03-2004', 5 );
INSERT INTO verifiche VALUES('INF',  4, '08-01-2004', 4 );
INSERT INTO verifiche VALUES('INF',  5, '08-04-2004', 6 );
INSERT INTO verifiche VALUES('INF',  6, '08-01-2004', 8 );
INSERT INTO verifiche VALUES('INF',  6, '08-05-2004', 6 );
INSERT INTO verifiche VALUES('INF',  7, '08-02-2004', 8 );
INSERT INTO verifiche VALUES('INF',  6, '08-02-2004', 6 );
INSERT INTO verifiche VALUES('INF',  7, '08-01-2004', 5 );
INSERT INTO verifiche VALUES('INF',  8, '08-03-2004', 7 );
INSERT INTO verifiche VALUES('INF',  9, '07-04-2004', 4 );

INSERT INTO verifiche VALUES('SIS',  1, '07-01-2004', 6 );
INSERT INTO verifiche VALUES('SIS',  5, '07-01-2004', 7 );
INSERT INTO verifiche VALUES('SIS',  2, '07-02-2004', 4 );
INSERT INTO verifiche VALUES('SIS',  3, '07-01-2004', 7 );
INSERT INTO verifiche VALUES('SIS',  4, '09-03-2004', 5 );
INSERT INTO verifiche VALUES('SIS',  5, '09-01-2004', 8 );
INSERT INTO verifiche VALUES('SIS',  6, '09-03-2004', 5 );
INSERT INTO verifiche VALUES('SIS',  7, '09-04-2004', 6 );
INSERT INTO verifiche VALUES('SIS',  8, '07-05-2004', 7 );
INSERT INTO verifiche VALUES('SIS',  9, '12-05-2004',10 );
INSERT INTO verifiche VALUES('SIS', 10, '12-02-2004', 9 );
INSERT INTO verifiche VALUES('SIS', 11, '12-03-2004', 8 );
INSERT INTO verifiche VALUES('SIS', 18, '12-04-2004', 3 );
INSERT INTO verifiche VALUES('SIS', 16, '12-05-2004', 4 );
INSERT INTO verifiche VALUES('SIS', 14, '12-01-2004', 3 );
INSERT INTO verifiche VALUES('SIS', 17, '12-02-2004', 8 );
INSERT INTO verifiche VALUES('SIS', 16, '12-03-2004', 5 );
INSERT INTO verifiche VALUES('SIS', 17, '12-04-2004', 9  );
INSERT INTO verifiche VALUES('SIS', 19, '12-05-2004', 6 );
INSERT INTO verifiche VALUES('SIS', 20, '12-05-2004', 7 );
INSERT INTO verifiche VALUES('SIS',  1, '12-02-2004', 6 );
INSERT INTO verifiche VALUES('SIS',  2, '12-01-2004', 8 );
INSERT INTO verifiche VALUES('SIS',  3, '12-03-2004', 9 );
INSERT INTO verifiche VALUES('SIS',  4, '12-01-2004', 5 );
INSERT INTO verifiche VALUES('SIS',  5, '12-04-2004', 7 );
INSERT INTO verifiche VALUES('SIS',  6, '12-01-2004', 7 );
INSERT INTO verifiche VALUES('SIS',  6, '12-05-2004', 5 );
INSERT INTO verifiche VALUES('SIS',  7, '12-02-2004', 7 );
INSERT INTO verifiche VALUES('SIS',  6, '12-02-2004', 8 );
INSERT INTO verifiche VALUES('SIS',  7, '12-01-2004', 7 );
INSERT INTO verifiche VALUES('SIS',  8, '12-03-2004', 8 );
INSERT INTO verifiche VALUES('SIS',  9, '12-04-2004', 6 );
