text: 
  USE tracker_DB;
  
  --Seed data from Patrick B--
  
  --add department
  INSERT INTO department
      (name)
  VALUES
      ("Human Resources"),
      ("R&D"),
      ("Engineering"),
      ("Accounting"),
      ("Sales");
  
  -- add role
  INSERT INTO role
      (title, salary, department_id)
  VALUES
  ("manager", 75000.00, 2),
  ("engineer", 52000, 3),
  ("accountant", 62500, 4),
  ("recruiter", 57500, 1),
  ("sales person", 85650, 5);
  
  --add employee
  INSERT INTO employee
      (first_name, last_name, role_id, manager_id)
  VALUES
  ("John", "Smith", 1, NULL),
  ("Jill", "Green", 1, 1),
  ("Jack", "Brown", 3, 2),
  ("Steve", "Quinn", 5, 2);