function viewAllEmployees() {
  console.log("All of PiedPiper's employees...\n");
  connection.query(
    "SELECT employee.id, employee.first_name, employee.last_name, role.title, department.name AS department, role.salary, CONCAT(manager.first_name, ' ', manager.last_name) AS manager FROM employee LEFT JOIN role ON employee.role_id = role.id LEFT JOIN department ON role.department_id = department.id LEFT JOIN employee manager ON manager.id = employee.manager_id", function (err, res) {
      if (err) throw err;
      console.table(res);
      openProcess();
    })
}
// first names, last names, job titles, departments, salaries, and manager that the employees report to
first names, last names, job titles, departments, salaries, and manager that the employees report to
first names last names job titles departments salaries and manager that the employees report to
function viewAllEmployees() {
  console.log("All of PiedPiper's employees...\n");
  connection.query(
    "SELECT employee.id, employee.first_name, employee.last_name, role.title, department.name AS department, role.salary, CONCAT(manager.first_name, ' ', manager.last_name) AS manager FROM employee LEFT JOIN role ON employee.role_id = role.id LEFT JOIN department ON role.department_id = department.id LEFT JOIN employee manager ON manager.id = employee.manager_id", function (err, res) {
      if (err) throw err;
      console.table(res);
      openProcess();
    })
}
function viewAllEmployees ( ) { console . log ( "All of PiedPiper's employees...\n" ) ; connection . query ( "SELECT employee.id, employee.first_name, employee.last_name, role.title, department.name AS department, role.salary, CONCAT(manager.first_name, ' ', manager.last_name) AS manager FROM employee LEFT JOIN role ON employee.role_id = role.id LEFT JOIN department ON role.department_id = department.id LEFT JOIN employee manager ON manager.id = employee.manager_id" , function ( err , res ) { if ( err ) throw err ; console . table ( res ) ; openProcess ( ) ; } ) }
first names, last names, job titles, departments, salaries, and manager that the employees report to
first names last names job titles departments salaries and manager that the employees report to