text: INSERT INTO
      department (name)
  VALUES
      ("Engineering"),
      ("Finance"),
      ("Legal"),
      ("Sales");
  
  INSERT INTO
      role (title, salary, department_id)
  VALUES
      ("Sales Lead", "100000", "4"),
      ("Salesperson", "80000", "4"),
      ("Lead Engineer", "150000", "1"),
      ("Software Engineer", "120000", "1"),
      ("Account Manager", "160000", "2"),
      ("Accountant", "125000", "2"),
      ("Lawyer", "190000", "3"),
      ("Legal Team Lead", "250000", "3");
  
  INSERT INTO
      employee (first_name, last_name, role_id, manager_id)
  VALUES
      ("John", "Doe", "1", NULL),
      ("Mike", "Chan", "2", "1"),
      ("Ashley", "Rodriguez", "3", NULL),
      ("Kevin", "Tupik", "4", "2"),
      ("Kunal", "Singh", "5", NULL),
      ("Malia", "Brown", "6", "3"),
      ("Sarah", "Lourd", "7", NULL),
      ("Tom", "Allen", "8", "4");