text: USE employeesDB;
  
  INSERT INTO department (name)
  VALUES 
  ("Engineering"),
  ("Research & Development"),
  ("Marketing"),
  ("Sales"),
  ("Accounts"),
  ("People Operations"),
  ("Legal"),
  ("Security");
  
  INSERT INTO role (title, salary, department_id)
  VALUES 
  ("FE Software Engineer", 97000, 1), 
  ("BE Software Engineer", 97000, 1), 
  ("Engineering Lead", 115000, 1), 
  ("Engineering Manager", 125000, 1), 
  ("R&D Engineer", 97000, 2), 
  ("R&D Engineering Lead", 115000, 2), 
  ("R&D Engineering Manager", 125000, 2), 
  ("Marketing Associate", 70000, 3), 
  ("Marketing Lead", 85000, 3), 
  ("Marketing Manager", 110000, 3), 
  ("Sales Associate", 65000, 4), 
  ("Sales Lead", 85000, 4), 
  ("Sales Manager", 110000, 4), 
  ("Accountant", 95000, 5), 
  ("Senior Accountant", 110000, 5), 
  ("Executive Assistant", 95000, 6), 
  ("Recruting Associate", 90000, 6), 
  ("Recruiting Lead", 105000, 6), 
  ("Recruiting Manager", 130000, 6), 
  ("Staff Coordinator", 65000, 6), 
  ("Training Manager", 100000, 6), 
  ("Employee Relations Manager", 110000, 6), 
  ("Legal Advisor", 120000, 7), 
  ("Senior Legal Advisor", 130000, 7), 
  ("Security Operations Lead", 100000, 8);
  
  INSERT INTO employee (first_name, last_name, role_id, manager_id)
  VALUES 
  ("Viktor", "Andreas", 1, 4), 
  ("Celestino", "Farmer", 2, 4), 
  ("Bernabé", "Sato", 3, 4), 
  ("Barbara", "Carman", 4, NULL), 
  ("Lotte", "Ríos", 5, 7), 
  ("Theresa", "Negrini", 6, 7), 
  ("Cahir", "Clery", 7, NULL), 
  ("Grigorios", "Eliot", 8, 10),
  ("Steffie", "Antonio", 9, 10), 
  ("Staffan", "Breen", 10, NULL), 
  ("Elena", "Rinn", 11, 13), 
  ("Kira", "Kilduff", 12, 13), 
  ("Lana", "Mingo", 13, NULL), 
  ("Aurel", "Summers", 14, 15), 
  ("Blas", "Scordato", 15, NULL), 
  ("Aparajita", "Gorman", 16, NULL), 
  ("Herbert", "Marley", 17, 19), 
  ("Christianne", "Márquez", 18, 19), 
  ("Tor", "Kerner", 19, NULL), 
  ("Norbert", "Austin", 20, 22), 
  ("Anneka", "Wilmer", 21, 22), 
  ("Terentiy", "Costanzo", 22, NULL), 
  ("Nikolai", "Leifsson", 23, 24), 
  ("Daniel", "Callaghan", 24, NULL), 
  ("Prem", "García", 25, NULL), 
  ("Olimpia", "Habich", 1, 4), 
  ("Stan", "Almstedt", 2, 4), 
  ("Dan", "Molina", 3, 4), 
  ("Tobias", "McCormick", 5, 7), 
  ("Heiner", "Kjellsson", 6, 7), 
  ("Vikram", "Anush", 8, 10), 
  ("Kaleb", "Hayley", 9, 10), 
  ("Nancy", "Lawrence", 11, 13), 
  ("Dyson", "Bove", 12, 13), 
  ("Kennedy", "Morse", 14, 15), 
  ("Lonny", "Derrick", 1, 4), 
  ("Yukiko", "Hiroshi", 2, 4), 
  ("Wiola", "Senior", 3, 4), 
  ("Poldi", "Foster", 5, 7);
  
  