query visit opd แยกตามสิทธิ์

SELECT
    p.hipdata_code,
    p.name AS pttype_name,
    COUNT(v.vn) AS visit_count
FROM
    vn_stat v
LEFT JOIN
    pttype p ON v.pttype = p.pttype
WHERE
    v.vstdate = CURDATE()
GROUP BY
    p.name
ORDER BY
    p.hipdata_code,visit_count DESC