นับ visit จากหัตถการ

SELECT
 io.ipt_oper_code,
 ic.icode,
 ic.NAME,
 COUNT( io.an ) AS count_an
FROM
 ipt_nurse_oper io
 LEFT JOIN ipt_oper_code ic ON ic.ipt_oper_code = io.ipt_oper_code
WHERE
 DATE(io.begin_date_time) BETWEEN 20240401
 AND CURDATE()
GROUP BY
 io.ipt_oper_code
ORDER BY
 count_an DESC