CREATE TABLE PROV(
ID NUMBER,
PROVIDER VARCHAR2(30),
AMOUNT NUMBER
);


INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES ( 1, 'VW Salzgitter', 10 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 2, 'VW Wolfsburg', 4 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 3, 'VW Hannover', 3 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 4, 'VW Braunschweig', 5 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 5, 'VW Salzgitter', 3 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 6, 'DB Mannheim', 8 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 7, 'DB Gaggenau', 2 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 8, 'DB Mannheim', 3 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 9, 'Audi Gyoer', 6 );
INSERT INTO PROV (ID,PROVIDER, AMOUNT) VALUES( 10, 'Audi Ingolstadt', 7 );