iT
select count(vn)as visit, count(distinct hn)as HN,(sum(inc01) + sum(inc02) + sum(inc03))as pLab,sum(inc12)as pDrung, sum(income)as pIncome
from vn_stat
where vstdate between "2021-10-01" and "2022-09-30"
and (pdx between "e11" and "e119" or pdx between "i10" and "i109")
PCC Notebook 2
{9F29F80C-10EB-4E42-8CF9-426C28FEF98C}
Onsite2 Doctors
{9423BE45-233E-44D0-A2DB-32246ECD9A30}
Onsite3 Pharma
{047132BF-E7B0-4C5F-8530-8A623D484782}
---------------------------------------------------
from vn_stat
where vstdate between "2021-10-01" and "2022-09-30"
and (pdx between "e11" and "e119" or pdx between "i10" and "i109")
PCC Notebook 2
{9F29F80C-10EB-4E42-8CF9-426C28FEF98C}
Onsite2 Doctors
{9423BE45-233E-44D0-A2DB-32246ECD9A30}
Onsite3 Pharma
{047132BF-E7B0-4C5F-8530-8A623D484782}
---------------------------------------------------