viewAllRoles() {
		return this.connection.query(
			`
            SELECT 
                role.id,
                role.title AS Title,
                department.name AS Department
            FROM 
                role
            LEFT JOIN 
                department ON role.department_id = department.id
            ORDER BY
                role.id;
            `
		);
	}
// View all roles and role's department by joining role and department table
View all roles and role's department by joining role and department table
View all roles and role ' s department by joining role and department table
viewAllRoles() {
		return this.connection.query(
			`
            SELECT 
                role.id,
                role.title AS Title,
                department.name AS Department
            FROM 
                role
            LEFT JOIN 
                department ON role.department_id = department.id
            ORDER BY
                role.id;
            `
		);
	}
viewAllRoles ( ) { return this . connection . query ( ` ` ) ; }
View all roles and role's department by joining role and department table
View all roles and role ' s department by joining role and department table