CREATE TABLE IF NOT EXISTS employees (
    emp_no      INT PRIMARY KEY,
    birth_date  DATE NOT NULL,
    first_name  VARCHAR(14) NOT NULL,
    last_name   VARCHAR(16) NOT NULL,
    gender      CHAR(1) NOT NULL,
    hire_date   DATE NOT NULL,
    email       VARCHAR(100)
);

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'),
(10051, '1953-07-28', 'Hidefumi', 'Caine', 'M', '1992-10-28', 'hidefumi.caine@example.com'),
(10052, '1961-02-26', 'Heping', 'Nitsch', 'M', '1988-11-11', 'heping.nitsch@example.com'),
(10053, '1954-09-13', 'Sanjiv', 'Zschoche', 'F', '1986-02-28', 'sanjiv.zschoche@example.com'),
(10054, '1957-04-04', 'Mayumi', 'Welbourne', 'M', '1995-03-13', 'mayumi.welbourne@example.com'),
(10055, '1956-06-06', 'Georgy', 'Dredge', 'M', '1992-04-27', 'georgy.dredge@example.com'),
(10056, '1961-09-01', 'Brendon', 'Bernini', 'F', '1990-02-01', 'brendon.bernini@example.com'),
(10057, '1954-05-30', 'Ebbe', 'Callaway', 'F', '1992-08-22', 'ebbe.callaway@example.com'),
(10058, '1955-10-08', 'Berhard', 'McFarlin', 'M', '1988-03-11', 'berhard.mcfarlin@example.com'),
(10059, '1953-04-11', 'Alejandro', 'McAlpine', 'M', '1991-06-15', 'alejandro.mcalpine@example.com'),
(10060, '1961-10-09', 'Breannda', 'Billingsley', 'M', '1987-11-17', 'breannda.billingsley@example.com'),
(10061, '1962-10-09', 'Tse', 'Herber', 'M', '1985-09-17', 'tse.herber@example.com'),
(10062, '1961-11-10', 'Anoosh', 'Peyn', 'M', '1991-08-30', 'anoosh.peyn@example.com'),
(10063, '1952-11-13', 'Gino', 'Leonhardt', 'F', '1992-04-11', NULL),
(10064, '1953-04-18', 'Udi', 'Jansch', 'M', '1985-11-20', 'udi.jansch@example.com'),
(10065, '1954-05-23', 'Satosi', 'Awdeh', 'M', '1988-03-02', 'satosi.awdeh@example.com'),
(10066, '1952-02-27', 'Kasturi', 'Nagata', 'F', '1991-05-14', 'kasturi.nagata@example.com'),
(10067, '1960-01-07', 'Kazuhiro', 'Cappello', 'F', '1986-08-11', 'kazuhiro.cappello@example.com'),
(10068, '1962-11-19', 'Crestez', 'Bouloucos', 'M', '1988-06-27', 'crestez.bouloucos@example.com'),
(10069, '1961-11-21', 'Hironobu', 'Haraldson', 'F', '1988-06-11', 'hironobu.haraldson@example.com'),
(10070, '1958-11-12', 'Petter', 'Stroustrup', 'M', '1987-03-19', 'petter.stroustrup@example.com'),
(10071, '1955-11-22', 'Bojan', 'Montemayor', 'M', '1989-02-10', 'bojan.montemayor@example.com'),
(10072, '1955-05-18', 'Suzette', 'Pettey', 'F', '1993-07-06', 'suzette.pettey@example.com'),
(10073, '1954-11-10', 'Yongqiao', 'Berztiss', 'M', '1995-04-14', 'yongqiao.berztiss@example.com'),
(10074, '1955-03-17', 'Shahaf', 'Famili', 'M', '1995-08-13', 'shahaf.famili@example.com'),
(10075, '1952-05-09', 'Prasadram', 'Heyers', 'M', '1987-07-28', 'prasadram.heyers@example.com'),
(10076, '1960-05-30', 'Pradeep', 'Makrucki', 'M', '1991-02-08', 'pradeep.makrucki@example.com'),
(10077, '1962-12-25', 'Huan', 'Lortz', 'M', '1986-02-06', 'huan.lortz@example.com'),
(10078, '1959-12-25', 'Suzette', 'Pettey', 'F', '1996-09-16', 'suzette.pettey@example.com'),
(10079, '1961-02-11', 'Lillian', 'Haddadi', 'M', '1990-05-21', 'lillian.haddadi@example.com'),
(10080, '1958-11-22', 'Parto', 'Bamford', 'M', '1995-05-31', 'parto.bamford@example.com'),
(10081, '1962-02-26', 'Guoxiang', 'Nooteboom', 'M', '1990-02-16', 'guoxiang.nooteboom@example.com'),
(10082, '1956-12-09', 'Kyoichi', 'Maliniak', 'M', '1991-06-19', 'kyoichi.maliniak@example.com'),
(10083, '1955-03-31', 'Hidefumi', 'Caine', 'M', '1988-02-12', 'hidefumi.caine@example.com'),
(10084, '1960-08-11', 'Moss', 'Shanbhogue', 'M', '1988-11-11', 'moss.shanbhogue@example.com'),
(10085, '1959-10-28', 'Bader', 'Swan', 'M', '1994-05-21', 'bader.swan@example.com'),
(10086, '1952-11-28', 'Arif', 'Merlo', 'M', '1990-02-14', 'arif.merlo@example.com'),
(10087, '1963-08-11', 'Berhard', 'McFarlin', 'M', '1992-06-04', 'berhard.mcfarlin@example.com'),
(10088, '1960-11-30', 'Tse', 'Herber', 'M', '1987-07-24', 'tse.herber@example.com'),
(10089, '1957-04-17', 'Kazuhito', 'Cappelletti', 'M', '1989-05-25', 'kazuhito.cappelletti@example.com'),
(10090, '1958-12-17', 'Otmar', 'Herbst', 'M', '1989-01-11', 'otmar.herbst@example.com'),
(10091, '1960-01-18', 'Florian', 'Syrotiuk', 'M', '1985-08-20', 'florian.syrotiuk@example.com'),
(10092, '1962-11-22', 'Bader', 'Swan', 'M', '1994-04-14', 'bader.swan@example.com'),
(10093, '1954-10-27', 'Yongqiao', 'Berztiss', 'M', '1991-03-14', 'yongqiao.berztiss@example.com'),
(10094, '1963-08-31', 'Prasadram', 'Heyers', 'M', '1990-08-19', 'prasadram.heyers@example.com'),
(10095, '1961-05-08', 'Divier', 'Reistad', 'F', '1992-01-17', 'divier.reistad@example.com'),
(10096, '1952-10-22', 'Suzette', 'Pettey', 'F', '1992-07-31', 'suzette.pettey@example.com'),
(10097, '1953-03-16', 'Parto', 'Bamford', 'M', '1993-08-16', 'parto.bamford@example.com'),
(10098, '1954-06-25', 'Kazuhito', 'Cappelletti', 'M', '1990-07-04', 'kazuhito.cappelletti@example.com'),
(10099, '1960-05-13', 'Bojan', 'Montemayor', 'M', '1988-04-17', 'bojan.montemayor@example.com'),
(10100, '1953-02-01', 'Georgi', 'Facello', 'M', '1992-08-26', 'georgi.facello@example.com');
