query เบาหวาน , CKD

SELECT
  p.hn,
  CONCAT(p.pname, p.fname, ' ', p.lname) AS ptname,
  p.sex,
  CASE
    WHEN p.sex = '1' THEN 'ชาย'
    WHEN p.sex = '2' THEN 'หญิง'
    ELSE 'ไม่ระบุ'
  END AS gender,
  TIMESTAMPDIFF(YEAR, p.birthday, v.vstdate) AS age,
  v.vstdate AS visit_date,
  dx.icd10 AS diagnosis,
  i.name AS drug_name,
  SUM(o.qty) AS qty,
  ROUND(SUM(o.sum_price),2) AS total_price
FROM ovst v
JOIN patient p ON p.hn = v.hn
JOIN ovstdiag dx ON dx.vn = v.vn AND dx.diagtype IN ('1','2')
JOIN opitemrece o ON o.vn = v.vn
JOIN drugitems i ON i.icode = o.icode
WHERE
  dx.icd10 IN ('E10', 'E11', 'E13', 'E14', 'N184', 'N185')
  AND v.vstdate BETWEEN '2024-10-01' AND '2025-09-30'
GROUP BY v.vn, dx.icd10, o.icode
ORDER BY v.hn,v.vstdate