CREATE TABLE IF NOT EXISTS employees (
    emp_no      INTEGER PRIMARY KEY,
    birth_date  TEXT NOT NULL,
    first_name  TEXT NOT NULL,
    last_name   TEXT NOT NULL,
    gender      TEXT NOT NULL,
    hire_date   TEXT NOT NULL,
    email       TEXT
);

INSERT INTO employees (emp_no, birth_date, first_name, last_name, gender, hire_date, email) VALUES
(10001, '1953-09-02', 'Georgi', 'Facello', 'M', '1986-06-26', 'georgi.facello@example.com'),
(10002, '1964-06-02', 'Bezalel', 'Simmel', 'F', '1985-11-21', 'bezalel.simmel@example.com'),
(10003, '1959-12-03', 'Parto', 'Bamford', 'M', '1986-08-28', 'parto.bamford@example.com'),
(10004, '1954-05-01', 'Chirstian', 'Koblick', 'M', '1986-12-01', 'chirstian.koblick@example.com'),
(10005, '1955-01-21', 'Kyoichi', 'Maliniak', 'M', '1989-09-12', 'kyoichi.maliniak@example.com'),
(10006, '1953-04-20', 'Anneke', 'Preusig', 'F', '1989-06-02', 'anneke.preusig@example.com'),
(10007, '1957-05-23', 'Tzvetan', 'Zielinski', 'F', '1989-02-10', 'tzvetan.zielinski@example.com'),
(10008, '1958-02-19', 'Saniya', 'Kalloufi', 'M', '1994-09-15', 'saniya.kalloufi@example.com'),
(10009, '1952-04-19', 'Sumant', 'Peac', 'F', '1985-02-18', 'sumant.peac@example.com'),
(10010, '1963-06-01', 'Duangkaew', 'Piveteau', 'F', '1989-08-24', 'duangkaew.piveteau@example.com'),
(10011, '1953-11-07', 'Mary', 'Sluis', 'F', '1990-01-22', NULL),
(10012, '1960-10-04', 'Patricio', 'Bridgland', 'M', '1992-12-18', 'patricio.bridgland@example.com'),
(10013, '1963-06-07', 'Eberhardt', 'Terkki', 'M', '1985-10-20', 'eberhardt.terkki@example.com'),
(10014, '1956-02-12', 'Berni', 'Genin', 'M', '1987-03-11', NULL),
(10015, '1959-08-19', 'Guoxiang', 'Nooteboom', 'M', '1987-07-02', 'guoxiang.nooteboom@example.com'),
(10016, '1961-05-02', 'Kazuhito', 'Cappelletti', 'M', '1995-01-27', 'kazuhito.cappelletti@example.com'),
(10017, '1958-07-06', 'Cristinel', 'Bouloucos', 'F', '1993-08-03', 'cristinel.bouloucos@example.com'),
(10018, '1954-06-19', 'Kazuhide', 'Peha', 'F', '1987-04-03', 'kazuhide.peha@example.com'),
(10019, '1953-01-23', 'Lillian', 'Haddadi', 'M', '1999-04-30', 'lillian.haddadi@example.com'),
(10020, '1952-12-24', 'Mayuko', 'Warwick', 'M', '1991-01-26', 'mayuko.warwick@example.com'),
(10021, '1960-02-20', 'Ramzi', 'Erde', 'M', '1988-02-10', 'ramzi.erde@example.com'),
(10022, '1952-07-08', 'Shahaf', 'Famili', 'M', '1995-12-15', 'shahaf.famili@example.com'),
(10023, '1953-09-29', 'Bojan', 'Montemayor', 'F', '1989-12-17', NULL),
(10024, '1958-09-05', 'Suzette', 'Pettey', 'F', '1997-05-19', 'suzette.pettey@example.com'),
(10025, '1958-10-31', 'Prasadram', 'Heyers', 'M', '1987-08-17', 'prasadram.heyers@example.com'),
(10026, '1953-04-03', 'Yongqiao', 'Berztiss', 'M', '1995-03-20', 'yongqiao.berztiss@example.com'),
(10027, '1962-07-10', 'Divier', 'Reistad', 'F', '1989-07-07', 'divier.reistad@example.com'),
(10028, '1963-11-26', 'Domenick', 'Tempesti', 'M', '1991-10-22', NULL),
(10029, '1956-12-13', 'Otmar', 'Herbst', 'M', '1985-11-20', 'otmar.herbst@example.com'),
(10030, '1958-07-14', 'Elvis', 'Demeyer', 'M', '1994-02-17', 'elvis.demeyer@example.com'),
(10031, '1959-01-27', 'Karsten', 'Joslin', 'M', '1991-09-01', 'karsten.joslin@example.com'),
(10032, '1960-08-09', 'Jeong', 'Reistad', 'F', '1990-06-20', 'jeong.reistad@example.com'),
(10033, '1956-11-14', 'Arif', 'Merlo', 'M', '1987-03-18', 'arif.merlo@example.com'),
(10034, '1962-12-29', 'Bader', 'Swan', 'M', '1988-09-21', 'bader.swan@example.com'),
(10035, '1953-02-08', 'Alain', 'Chappelet', 'M', '1988-09-05', 'alain.chappelet@example.com'),
(10036, '1959-11-07', 'Adamantios', 'Portugali', 'M', '1992-01-03', 'adamantios.portugali@example.com'),
(10037, '1963-07-22', 'Pradeep', 'Makrucki', 'M', '1990-12-05', 'pradeep.makrucki@example.com'),
(10038, '1960-07-20', 'Huan', 'Lortz', 'M', '1989-09-27', 'huan.lortz@example.com'),
(10039, '1959-10-01', 'Alejandro', 'Brender', 'M', '1988-01-19', 'alejandro.brender@example.com'),
(10040, '1958-01-21', 'Weiyi', 'Meriste', 'F', '1993-02-14', 'weiyi.meriste@example.com'),
(10041, '1959-08-27', 'Uri', 'Lenart', 'F', '1989-11-12', 'uri.lenart@example.com'),
(10042, '1956-02-26', 'Magy', 'Stafford', 'M', '1988-11-24', NULL),
(10043, '1960-09-19', 'Yishay', 'Tzvieli', 'M', '1990-10-20', 'yishay.tzvieli@example.com'),
(10044, '1953-01-29', 'Mingsen', 'Casley', 'M', '1994-05-21', 'mingsen.casley@example.com'),
(10045, '1960-05-30', 'Moss', 'Shanbhogue', 'M', '1989-09-02', 'moss.shanbhogue@example.com'),
(10046, '1957-10-15', 'Lucien', 'Rosenbaum', 'F', '1992-06-20', 'lucien.rosenbaum@example.com'),
(10047, '1962-06-15', 'Zvonko', 'Nyanchama', 'M', '1989-03-31', 'zvonko.nyanchama@example.com'),
(10048, '1963-07-11', 'Florian', 'Syrotiuk', 'M', '1985-03-27', 'florian.syrotiuk@example.com'),
(10049, '1961-09-11', 'Basil', 'Tramer', 'F', '1992-05-04', 'basil.tramer@example.com'),
(10050, '1958-05-21', 'Yinghua', 'Dredge', 'M', '1988-11-25', 'yinghua.dredge@example.com');
