select st.post, round( avg( timestampdiff (second, att.first_clockin, att.last_clockin) / 3600 ), 3 ) work_hours from test.staff_tb st join test.attendent_tb att on st.staff_id = att.staff_id where att.first_clockin is not null and att....