select s.post,
    avg(timestampdiff(minute, a.first_clockin	, a.last_clockin)/60) as work_hours
from staff_tb s
left join attendent_tb a
USING (staff_id)
group by post
order by work_hours desc