select HN
from(
SELECT convert(varchar(10), [IREQ_OD_DT], 120) as OrderDate
      ,[IREQ_PID] as HN
  FROM [view_lab_information_Request ]
  where IREQ_INACTIVE = 'N' and IREQ_SRC_CODE = 'OPD'and  IREQ_LAST_CHK_DT between '2022-01-01 00:00' and '2026-05-02 23:59'
  ) as x
group by OrderDate, HN