CREATE TABLE Personal (
  Personalnummer int not null,
  Vorname char(30),
  Name char(30),
  Strasse char(30),
  PLz char(5),
  Ort char(30),
  Geburt date,
  Geschlecht char(1),
  Gehalt double,
  primary key (Personalnummer)
);


INSERT INTO Personal VALUES (1002,'Kai','Mueller','Hallesche Str. 16','04838','Eilenburgn','1951-12-28','M',3400.01);
INSERT INTO Personal VALUES (1005,'Ede','Pfau','Nicoleiplatz 2','04232','Leipzig','1952-08-02','M',4500.02);
INSERT INTO Personal VALUES (1008,'Eiki','Taro','Musterstr. 6','09999','Musterdorf','1947-09-10','M',5100.03);
INSERT INTO Personal VALUES (1010,'Juergen','Marx','Musterstr. 12','09999','Musterdorf','1956-03-22','M',3677.04);
INSERT INTO Personal VALUES (1015,'Eerik','Wicki','Boltern-Weg 3','22587','Hamburg','1950-07-09','M',4533.05);
INSERT INTO Personal VALUES (1016,'Ulrich','Mueller','Weide Str. 2a','04838','Hohenpriessnitz','1951-01-02','M',8999.06);
INSERT INTO Personal VALUES (1017,'Klaus','Ecke','Schulze-Str. 11','04808','Wurzen','1955-04-13','M',2555.07);
INSERT INTO Personal VALUES (1100,'Kerstin','Gans','Hauptstr. 10','04838','Moerlitz','1961-03-19','W',6000.08);
INSERT INTO Personal VALUES (1101,'Guenter','Maus','Bergstrasse 5','06108','Halle/Saale','1948-12-21','M',4500.00);
INSERT INTO Personal VALUES (1112,'Hannes','Heik','Musterstr. 145','09999','Musterdorf','1961-02-06','M',5600.10);
INSERT INTO Personal VALUES (1113,'Karl','Seppa','Musterstr. 7','09999','Musterdorf','1963-06-24','M',3400.11);
INSERT INTO Personal VALUES (1114,'Karsten','Mueller','Musterstr. 3','09999','Musterdorf','1963-07-12','M',4900.12);
INSERT INTO Personal VALUES (1429,'Torsten','Mieder','Hauptstrasse 16','04838','Laussig','1971-05-15','M',5400.13);
INSERT INTO Personal VALUES (1430,'Christine','Schwarz','Musterstr. 8','0999','Musterdorf','1948-04-24','W',5420.14);
INSERT INTO Personal VALUES (1431,'Birgit','Gemse','Bauernkoppeln 39','22393','Hamburg','1958-01-13','W',1200.15);
INSERT INTO Personal VALUES (1432,'Bernd','Jach','Suelldorferstr.','22589','Hamburg','1959-05-10','M',2455.16);
INSERT INTO Personal VALUES (1433,'Silvia','Munter','Treppe 7','22587','Hamburg','1952-04-28','W',4555.17);
INSERT INTO Personal VALUES (1434,'Joerg','Schoen','Dorfweg 25 a','22589','Hamburg','1969-08-20','M',5600.18);
INSERT INTO Personal VALUES (1435,'Peter','Schock','Weststrasse 2','74323','Abstatt','1944-11-02','M',4700.19);
INSERT INTO Personal VALUES (1436,'Hans-Juergen','Sieg','Gerberstrasse 10','24568','Winsen','1947-05-22','M',7000.20);
INSERT INTO Personal VALUES (1437,'Christa','Renner','Weidenstrasse 26','15469','Halsenbek','1932-12-27','W',3900.21);
INSERT INTO Personal VALUES (1438,'Manfred','Stach','Gerbergasse 7','04105','Leipzig','1946-09-26','M',3500.00);
INSERT INTO Personal VALUES (1439,'Elfi','Kaufmann','Brandstrasse 15 e','04827','Gerichshain','1966-01-29','W',3900.22);