CREATE TABLE "employees" (
  "employee_id" INT,
  "full_name" VARCHAR(100),
  "job_title" VARCHAR(60),
  "department" VARCHAR(40),
  "salary" INT,
  "hire_date" DATE,
  "office_city" VARCHAR(60),
  "manager_email" VARCHAR(120)
);

INSERT INTO "employees" ("employee_id", "full_name", "job_title", "department", "salary", "hire_date", "office_city", "manager_email") VALUES
  (1000, 'Amira Williams', 'Marketing Manager', 'Marketing', 58681, '2024-08-16', 'Cluj-Napoca', 'amira.williams@example.test'),
  (1001, 'Jessica Suzuki', 'Frontend Developer', 'Sales', 98828, '2021-01-07', 'Ankara', 'jessica.suzuki@example.test'),
  (1002, 'Elizabeth White', 'CTO', 'Product', 142506, '2024-02-11', 'Abu Dhabi', 'elizabethwhite@example.invalid'),
  (1003, 'Leyla Schneider', 'Test Automation Engineer', 'Support', 101002, '2024-12-23', 'Marseille', 'leyla_schneider@example.com'),
  (1004, 'Hugo Öztürk', 'Product Manager', 'Human Resources', 44432, '2026-04-03', 'Amsterdam', 'hugoozturk73@example.test'),
  (1005, 'Liam Ali', 'Site Reliability Engineer', 'Operations', 142265, '2025-05-03', 'Prague', 'liam_ali@example.test'),
  (1006, 'Karim Meyer', 'Test Automation Engineer', 'Marketing', 44217, '2022-06-16', 'Osaka', NULL),
  (1007, 'Lucía Ferrari', 'UX Designer', 'Operations', 123703, '2024-04-27', 'Santiago', 'lucia_ferrari@example.test'),
  (1008, 'Sophia Wilson', 'Account Executive', 'Marketing', 86473, '2020-03-18', 'Zurich', 'sophia.wilson@example.org'),
  (1009, 'Diego Sato', 'Mobile Developer', 'Support', 179629, '2024-10-26', 'Chicago', NULL),
  (1010, 'Aylin Patel', 'CTO', 'Support', 89689, '2024-03-04', 'The Hague', 'aylin_patel18@example.net'),
  (1011, 'Amelia Romano', 'Business Analyst', 'Operations', 39098, '2024-10-22', 'Aarhus', 'amelia.romano@example.org'),
  (1012, 'Mia Ito', 'Support Specialist', 'Operations', 177480, '2024-04-02', 'Izmir', 'mia_ito96@example.com'),
  (1013, 'Priya Kılıç', 'Security Analyst', 'Support', 44847, '2022-04-22', 'Singapore', 'priya.kilic@example.invalid'),
  (1014, 'William Singh', 'Technical Writer', 'Engineering', 149903, '2025-10-03', 'Geneva', 'william_singh@example.test'),
  (1015, 'Emma Wright', 'Account Executive', 'Human Resources', 118593, '2024-06-09', 'Kyiv', 'emma.wright@example.org'),
  (1016, 'Ethan King', 'Support Specialist', 'Marketing', 135965, '2022-04-15', 'Antwerp', 'ethan.king38@example.org'),
  (1017, 'Ren Ferrari', 'Senior Software Engineer', 'Engineering', 110996, '2020-05-11', 'Bergen', 'ren_ferrari@example.net'),
  (1018, 'Lars Taylor', 'Office Manager', 'Human Resources', 89811, '2024-12-09', 'Antwerp', 'lars.taylor@example.net'),
  (1019, 'Liam Tanaka', 'Database Administrator', 'Marketing', 83629, '2020-12-19', 'Ho Chi Minh City', 'liamtanaka@example.org'),
  (1020, 'Mei Williams', 'QA Engineer', 'Finance', 169287, '2021-05-20', 'Los Angeles', NULL),
  (1021, 'Felix Romano', 'CTO', 'Design', 90078, '2024-06-04', 'Cork', 'felixromano@example.com'),
  (1022, 'Barbara Thomas', 'UX Designer', 'Marketing', 51273, '2024-01-28', 'Cebu', 'barbara_thomas2@example.org'),
  (1023, 'Richard Aziz', 'Data Scientist', 'Data', 72557, '2022-10-28', 'Ho Chi Minh City', 'richardaziz@example.net'),
  (1024, 'Sophia Ahmed', 'Marketing Manager', 'Engineering', 38360, '2024-05-04', 'Guadalajara', NULL),
  (1025, 'Fatima Thomas', 'Data Scientist', 'Engineering', 43064, '2020-04-22', 'Sydney', 'fatimathomas@example.test'),
  (1026, 'Linda Ferrari', 'Business Analyst', 'Design', 63814, '2022-03-21', 'Oslo', 'lindaferrari38@example.invalid'),
  (1027, 'Sandra Nasser', 'Mobile Developer', 'Operations', 74217, '2024-07-18', 'Stockholm', 'sandranasser@example.org'),
  (1028, 'Kenji Iyer', 'Marketing Manager', 'Marketing', 141368, '2024-08-25', 'Porto', 'kenji_iyer@example.invalid'),
  (1029, 'Harper Thompson', 'Research Scientist', 'Product', 123526, '2021-09-13', 'Kyiv', 'harper_thompson93@example.test'),
  (1030, 'Chiara Colombo', 'Scrum Master', 'IT', 67688, '2022-02-23', 'Abu Dhabi', 'chiaracolombo@example.org'),
  (1031, 'Deniz Martinez', 'QA Engineer', 'IT', 68260, '2024-07-19', 'Houston', 'deniz_martinez24@example.org'),
  (1032, 'Ren Torres', 'Research Scientist', 'Quality Assurance', 49050, '2024-10-28', 'Lisbon', 'ren.torres61@example.test'),
  (1033, 'Aylin Aziz', 'Scrum Master', 'Support', 100816, '2023-06-21', 'Kuala Lumpur', 'aylinaziz@example.org'),
  (1034, 'Clara Lewis', 'Sales Representative', 'IT', 75304, '2025-08-11', 'Valparaíso', NULL),
  (1035, 'Nina Rahman', 'Research Scientist', 'Legal', 135077, '2025-11-17', 'Surabaya', 'nina.rahman98@example.net'),
  (1036, 'Marco Schneider', 'Financial Analyst', 'Finance', 147178, '2023-02-23', 'Athens', 'marco_schneider52@example.test'),
  (1037, 'Nancy Yılmaz', 'Legal Counsel', 'Design', 175049, '2025-09-18', 'São Paulo', 'nancyyilmaz@example.net'),
  (1038, 'Patricia White', 'Systems Administrator', 'Engineering', 95758, '2021-01-09', 'Amsterdam', 'patricia_white26@example.com'),
  (1039, 'Elizabeth Yılmaz', 'Mobile Developer', 'Data', 174931, '2023-08-07', 'Amsterdam', 'elizabeth.yilmaz@example.com'),
  (1040, 'Emma Hassan', 'Software Engineer', 'Finance', 142278, '2020-11-10', 'Brno', 'emma_hassan@example.org'),
  (1041, 'Robert Saito', 'CTO', 'Finance', 160457, '2021-11-21', 'Cluj-Napoca', 'robertsaito@example.invalid'),
  (1042, 'Elena Hayashi', 'Product Manager', 'Data', 128902, '2022-04-07', 'Geneva', 'elena.hayashi@example.net'),
  (1043, 'Zeynep Romano', 'DevOps Engineer', 'Legal', 113213, '2021-05-17', 'Stockholm', 'zeynepromano@example.com'),
  (1044, 'Luca Kobayashi', 'Database Administrator', 'Product', 100323, '2024-03-18', 'Manchester', 'luca.kobayashi58@example.invalid'),
  (1045, 'Isha Kobayashi', 'DevOps Engineer', 'Design', 156341, '2020-09-06', 'Los Angeles', 'ishakobayashi@example.test'),
  (1046, 'Matthew Flores', 'Business Analyst', 'Engineering', 101440, '2024-07-16', 'Oslo', 'matthewflores@example.invalid'),
  (1047, 'Sofia Schulz', 'Technical Writer', 'Legal', 143587, '2021-10-31', 'Nairobi', 'sofia.schulz53@example.invalid'),
  (1048, 'Charles Çelik', 'Engineering Manager', 'Operations', 110345, '2026-06-29', 'Buenos Aires', 'charles_celik@example.net'),
  (1049, 'Harper Ricci', 'Frontend Developer', 'Operations', 169011, '2022-05-20', 'Ho Chi Minh City', 'harper_ricci@example.test'),
  (1050, 'Karen Bianchi', 'SDET', 'Quality Assurance', 161085, '2024-01-09', 'Arequipa', 'karenbianchi@example.org'),
  (1051, 'Harper Ahmed', 'Sales Representative', 'Support', 48052, '2025-06-07', 'Istanbul', 'harper_ahmed@example.invalid'),
  (1052, 'Zeynep Clark', 'Senior Software Engineer', 'Marketing', 111903, '2026-05-24', 'Geneva', 'zeynep_clark@example.org'),
  (1053, 'Emre Singh', 'Security Analyst', 'Research & Development', 143390, '2021-01-19', 'Budapest', 'emresingh84@example.com'),
  (1054, 'Emma Clark', 'Frontend Developer', 'IT', 178425, '2024-07-02', 'Vienna', 'emma_clark77@example.test'),
  (1055, 'Kenji Aziz', 'Product Manager', 'Operations', 154697, '2020-02-11', 'Alexandria', 'kenji.aziz@example.invalid'),
  (1056, 'James Schulz', 'Engineering Manager', 'Operations', 71355, '2024-03-22', 'Medellín', 'james.schulz@example.com'),
  (1057, 'Karen Yılmaz', 'Backend Developer', 'Engineering', 168270, '2023-08-23', 'Antwerp', 'karen.yilmaz97@example.invalid'),
  (1058, 'Michael Nasser', 'QA Engineer', 'Data', 39053, '2025-12-04', 'Brisbane', 'michael.nasser@example.com'),
  (1059, 'Hugo Müller', 'Database Administrator', 'Marketing', 122836, '2022-11-20', 'New York', NULL),
  (1060, 'Anthony Brown', 'Customer Success Manager', 'Sales', 61395, '2024-01-13', 'Dublin', 'anthony.brown@example.org'),
  (1061, 'Anthony Ramirez', 'Technical Writer', 'Product', 125483, '2025-04-24', 'Kuala Lumpur', 'anthony.ramirez52@example.test'),
  (1062, 'Liam Iyer', 'Solutions Architect', 'Quality Assurance', 172449, '2022-06-01', 'Graz', 'liam_iyer88@example.test'),
  (1063, 'Charles Moore', 'QA Engineer', 'Marketing', 141230, '2022-07-21', 'Stockholm', NULL),
  (1064, 'Emma Lopez', 'Legal Counsel', 'Marketing', 153015, '2023-12-30', 'Shenzhen', 'emmalopez47@example.invalid'),
  (1065, 'Barbara Williams', 'Site Reliability Engineer', 'Engineering', 162054, '2021-08-19', 'Gothenburg', NULL),
  (1066, 'Karen Thomas', 'Engineering Manager', 'Data', 119357, '2025-07-15', 'Chiang Mai', 'karen_thomas@example.net'),
  (1067, 'Lisa Gupta', 'HR Specialist', 'Support', 140941, '2024-08-10', 'Tel Aviv', 'lisa_gupta83@example.org'),
  (1068, 'Priya Esposito', 'Office Manager', 'Research & Development', 172772, '2022-10-25', 'Mumbai', 'priya.esposito@example.com'),
  (1069, 'Christopher Russo', 'QA Engineer', 'IT', 139607, '2022-06-18', 'Valencia', 'christopher_russo53@example.com'),
  (1070, 'Hiro Scott', 'Project Manager', 'Sales', 50597, '2020-08-18', 'Toronto', 'hiro_scott43@example.com'),
  (1071, 'Can Ali', 'Product Manager', 'Quality Assurance', 48100, '2024-05-03', 'Bangalore', 'canali@example.org'),
  (1072, 'Ethan Clark', 'Engineering Manager', 'IT', 139880, '2023-02-11', 'Brussels', 'ethanclark@example.org'),
  (1073, 'William Moore', 'Full Stack Developer', 'Engineering', 94953, '2022-12-27', 'Buenos Aires', 'william.moore@example.net'),
  (1074, 'Anthony Meyer', 'Support Specialist', 'Legal', 80009, '2025-12-02', 'Graz', 'anthony.meyer@example.invalid'),
  (1075, 'Daniel Öztürk', 'Mobile Developer', 'Quality Assurance', 78691, '2021-12-10', 'Copenhagen', 'danielozturk@example.org'),
  (1076, 'Jennifer Arslan', 'SDET', 'Legal', 130306, '2021-07-11', 'Shanghai', 'jennifer_arslan69@example.invalid'),
  (1077, 'Priya Müller', 'Support Specialist', 'Design', 125361, '2024-08-01', 'Dubai', 'priya.muller17@example.test'),
  (1078, 'Hassan Arslan', 'Accountant', 'Product', 107950, '2023-07-11', 'Graz', 'hassanarslan72@example.org'),
  (1079, 'Ethan Wagner', 'Senior Software Engineer', 'Legal', 175837, '2025-08-26', 'Debrecen', 'ethan_wagner@example.invalid'),
  (1080, 'Elena Ahmed', 'Network Engineer', 'Marketing', 102020, '2020-03-11', 'Delhi', 'elena_ahmed@example.invalid'),
  (1081, 'Mehmet Tanaka', 'SDET', 'Design', 141111, '2021-07-17', 'Tel Aviv', 'mehmet.tanaka55@example.org'),
  (1082, 'Priya Demir', 'Data Scientist', 'Finance', 149661, '2021-01-11', 'Seville', 'priya_demir@example.test'),
  (1083, 'Elif Kumar', 'Accountant', 'Finance', 91075, '2024-06-01', 'Vienna', 'elifkumar64@example.com'),
  (1084, 'Hiro Ferrari', 'Engineering Manager', 'Design', 63724, '2023-10-10', 'Buenos Aires', 'hiroferrari@example.test'),
  (1085, 'Daniel Kobayashi', 'Financial Analyst', 'IT', 54237, '2022-07-28', 'Madrid', 'daniel.kobayashi@example.net'),
  (1086, 'Can Rossi', 'HR Specialist', 'Research & Development', 152786, '2026-05-27', 'Antwerp', NULL),
  (1087, 'Daniel Anderson', 'Solutions Architect', 'Product', 50864, '2020-08-06', 'Johannesburg', 'danielanderson@example.com'),
  (1088, 'Liam Lewis', 'QA Engineer', 'Data', 101607, '2024-01-20', 'Buenos Aires', 'liam.lewis97@example.org'),
  (1089, 'Fatima Wright', 'Site Reliability Engineer', 'Product', 133574, '2022-02-18', 'Shanghai', 'fatima_wright@example.net'),
  (1090, 'Ethan Davis', 'Database Administrator', 'Product', 67558, '2021-05-08', 'Valparaíso', 'ethandavis35@example.invalid'),
  (1091, 'Fatima Thompson', 'Marketing Manager', 'Design', 100918, '2021-09-23', 'Cluj-Napoca', 'fatimathompson41@example.invalid'),
  (1092, 'Lisa Robinson', 'Account Executive', 'Quality Assurance', 90968, '2022-11-03', 'Madrid', 'lisa.robinson38@example.com'),
  (1093, 'Ingrid Marino', 'Data Analyst', 'Finance', 47474, '2025-12-08', 'Tampere', 'ingridmarino63@example.com'),
  (1094, 'Liam Russo', 'Senior Software Engineer', 'IT', 169708, '2025-09-16', 'Jeddah', 'liam_russo54@example.org'),
  (1095, 'Lars Kimura', 'Marketing Manager', 'Marketing', 129090, '2024-10-28', 'Auckland', 'larskimura15@example.invalid'),
  (1096, 'Daniel Öztürk', 'Software Engineer', 'Finance', 123743, '2021-09-18', 'Frankfurt', 'danielozturk@example.test'),
  (1097, 'Elena Tanaka', 'Database Administrator', 'Human Resources', 94388, '2025-02-09', 'Surabaya', NULL),
  (1098, 'Lars Young', 'Research Scientist', 'Sales', 164444, '2025-05-11', 'Mombasa', 'lars_young@example.test'),
  (1099, 'Diego White', 'Solutions Architect', 'Engineering', 126906, '2020-11-21', 'Manila', 'diego.white6@example.invalid');
