数字IC offer 选择

SELECT department, CONCAT(ROUND(SUM(IF(TIMESTAMPDIFF(MINUTE,first_clockin, last_clockin) > 9.5*60, 1, 0))/COUNT(a.staff_id)*100,1),'%') AS ratio FROM attendent_tb a LEFT JOIN staff_tb ON a.staff_id = staff_tb.staff_id GROUP BY department ORDER BY ratio DESC; 注：TIMESTAMPDIFF(HOUR, first_clockin, l...

格兰菲还在开吗。验证岗

华子求求了！