function viewRoles() {
    db.query(
        'SELECT title, salary, department_id, department.name as dept_name from role inner join department on role.department_id=department.id',
        function (err, results) {
            if (err) throw err;
            console.table(results);
            comfirmPrompt();
        }
    );
}
//function to query and display all roles
function to query and display all roles
function to query and display all roles
function viewRoles() {
    db.query(
        'SELECT title, salary, department_id, department.name as dept_name from role inner join department on role.department_id=department.id',
        function (err, results) {
            if (err) throw err;
            console.table(results);
            comfirmPrompt();
        }
    );
}
function viewRoles ( ) { db . query ( 'SELECT title, salary, department_id, department.name as dept_name from role inner join department on role.department_id=department.id' , function ( err , results ) { if ( err ) throw err ; console . table ( results ) ; comfirmPrompt ( ) ; } ) ; }
function to query and display all roles
function to query and display all roles