function viewEmployees() {
    db.query(
        'Select first_name, last_name, role_id as role, manager_id as manager,role.salary, role.title as role from employee inner join role on employee.role_id=role.id',
        function (err, results) {
            if (err) throw err;
            console.table(results);
            comfirmPrompt();
        }
    );
}
//function to query and display all employees
function to query and display all employees
function to query and display all employees
function viewEmployees() {
    db.query(
        'Select first_name, last_name, role_id as role, manager_id as manager,role.salary, role.title as role from employee inner join role on employee.role_id=role.id',
        function (err, results) {
            if (err) throw err;
            console.table(results);
            comfirmPrompt();
        }
    );
}
function viewEmployees ( ) { db . query ( 'Select first_name, last_name, role_id as role, manager_id as manager,role.salary, role.title as role from employee inner join role on employee.role_id=role.id' , function ( err , results ) { if ( err ) throw err ; console . table ( results ) ; comfirmPrompt ( ) ; } ) ; }
function to query and display all employees
function to query and display all employees