text: INSERT INTO department (name)
  VALUES ("Sales"), ("Engineering"), ("Finance"), ("Legal"),('Human Resources');
  
  INSERT INTO role (title, salary, department_id)
  VALUES ("VP Sales", 100000, 1), /* 1 */
           ("Salesperson", 80000, 1), /* 2 */
           ("Lead Engineer", 150000, 2), /* 3 */
           ("Software Engineer", 120000, 2), /* 4 */
           ("Accountant", 125000, 3), /* 5 */
           ("Lead Lawyer", 190000, 4), /* 6 */
           ("Lawyer", 130000, 4); /* 7 */
          ('VP Human Resources', 190000, 5), /* 8 */
          ('Human Resource Generalist', 65000, 5); /* 9 */
  
  INSERT INTO employee (first_name, last_name, role_id, manager_id)
  VALUES ("Iggy", "Pop", 3, null), 
          ("Johnny", "Rotton", 1, null),
          ("Lou", "Reed", 6, null),
          ("Debra", "Harry", 4, null),
          ("Henry", "Rollins", 2, null),
          ("Jello", "Biafra", 7, null), 
          ("Siouxsie", "Sioux", 5, null); 
          ("Sid", "Vicious", 8, null), 
          ("Joan", "Jett", 9, null); 