SELECT `a`.*, `b`.`name` as `department_name`, `c`.`name` as `branch_name`
FROM `view__count_job` `a`
JOIN `company__department` `b` ON `b`.`id` = `a`.`departmentID`
JOIN `company__branch` `c` ON `c`.`id` = `b`.`branch_id`
WHERE `b`.`name` = 'Audit and Assurance'
ORDER BY `b`.`name` ASC