SELECT *
FROM dbo.view_lab_statistic_Order_List AS v
WHERE v.[REQ ITEM CODE] IN ('SR065', 'SRT079')
  AND v.[REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000' 
                                        AND '2025-09-30 00:00:00.000'
  AND v.[HN] IN (
        SELECT [HN]
        FROM dbo.view_lab_statistic_Order_List
        WHERE [REQ ITEM CODE] IN ('SR065', 'SRT079')
          AND [REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000' 
                                              AND '2025-09-30 00:00:00.000'
        GROUP BY [HN]
        HAVING COUNT(*) > 1
  )
ORDER BY
    v.[HN];


/*
SELECT *
FROM dbo.view_lab_statistic_Order_List AS v
WHERE v.[REQ ITEM CODE] IN ('SR065', 'SRT079')
  AND v.[REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000' 
                                        AND '2025-09-30 00:00:00.000'
  AND v.[HN] IN (
        SELECT [HN]
        FROM dbo.view_lab_statistic_Order_List
        WHERE [REQ ITEM CODE] IN ('SR065', 'SRT079')
          AND [REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000' 
                                              AND '2025-09-30 00:00:00.000'
        GROUP BY [HN]
        HAVING COUNT(*) > 1
  );




/*SELECT
    [HN],
    COUNT(*) AS OrderCount
FROM
    dbo.view_lab_statistic_Order_List
WHERE
    [REQ ITEM CODE] IN ('SR065', 'SRT079')
    AND [REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000' 
                                        AND '2025-09-30 00:00:00.000'
GROUP BY
    [HN]
HAVING
    COUNT(*) > 1;
*/