text: USE employee_manager;
  
  -- Create department data rows --
  INSERT INTO department (name) VALUES ("Sales");
  INSERT INTO department (name) VALUES ("Engineering");
  INSERT INTO department (name) VALUES ("Finance");
  INSERT INTO department (name) VALUES ("Legal");
  
  -- Create role data rows --
  INSERT INTO role (title,salary,department_id) 
  VALUES ("Sales Lead", 100000, 1);
  
  INSERT INTO role (title,salary,department_id) 
  VALUES ("Salesperson", 80000, 1);
  
  INSERT INTO role (title,salary,department_id) 
  VALUES ("Lead Engineer", 150000, 2);
  
  INSERT INTO role (title,salary,department_id) 
  VALUES ("Software Engineer", 120000, 2);
  
  INSERT INTO role (title,salary,department_id) 
  VALUES ("Accountant", 125000, 3);
  
  INSERT INTO role (title,salary,department_id) 
  VALUES ("Legal Team Lead", 250000, 4);
  
  INSERT INTO role (title,salary,department_id) 
  VALUES ("Lawyer", 190000, 4);
  
  -- Create employee data rows --
  INSERT INTO employee (first_name,last_name,role_id,manager_id) 
  VALUES ("Ashley","Rodriguez",3,null);
  
  INSERT INTO employee (first_name,last_name,role_id,manager_id) 
  VALUES ("Malia","Brown",5,null);
  
  INSERT INTO employee (first_name,last_name,role_id,manager_id) 
  VALUES ("Sarah","Lourd",6,null);
  
  INSERT INTO employee (first_name,last_name,role_id,manager_id) 
  VALUES ("John","Doe",1,1);
  
  INSERT INTO employee (first_name,last_name,role_id,manager_id) 
  VALUES ("Mike","Chan",2,4);
  
  INSERT INTO employee (first_name,last_name,role_id,manager_id) 
  VALUES ("Kevin","Turk",4,1);
  
  INSERT INTO employee (first_name,last_name,role_id,manager_id) 
  VALUES ("Tom","Allen",7,3);
  