DECLARE @d1 DATE = '2025-10-01';
DECLARE @d2 DATE = '2026-03-30';

WITH Sub AS (
    SELECT 
        HN,
        DATEDIFF(day, 
            LAG([REQ ITEM CHECKIN DATETIME]) OVER (
                PARTITION BY HN, [REQ ITEM CODE] 
                ORDER BY [REQ ITEM CHECKIN DATETIME]
            ), 
            [REQ ITEM CHECKIN DATETIME]
        ) AS Days_Diff
    FROM view_lab_statistic_Order_List
    WHERE [REQ ITEM CHECKIN DATETIME] BETWEEN @d1 AND @d2
)
SELECT 
    COUNT(DISTINCT CASE WHEN Days_Diff BETWEEN 1 AND 89 THEN HN END) AS [จำนวนคนที่ซ้ำ],
    COUNT(DISTINCT HN) AS [จำนวนคนทั้งหมด],
    ROUND(
        CAST(COUNT(DISTINCT CASE WHEN Days_Diff BETWEEN 1 AND 89 THEN HN END) AS FLOAT) 
        / NULLIF(COUNT(DISTINCT HN),0) * 100, 2
    ) AS [ร้อยละคนที่ซ้ำ (%)]
FROM Sub;