Untitled

WITH LastActions AS (
    SELECT 
        [FIRM_CODE],
        [COMPANY_CODE],
        [POLICY_NO],
        [PRODUCT_NO],
        [RENEWAL_NO],
        [ENDORS_NO],
        [ACTION],
        [DATE],
        ROW_NUMBER() OVER (
            PARTITION BY [FIRM_CODE], [COMPANY_CODE], [PRODUCT_NO], 
                         [POLICY_NO], [RENEWAL_NO], [ENDORS_NO]
            ORDER BY 
                [DATE] DESC,
                CASE [ACTION]
                    WHEN 'DELETE' THEN 1
                    WHEN 'UPDATE' THEN 2
                    WHEN 'INSERT' THEN 3
                    ELSE 4
                END ASC
        ) AS rn
    FROM [WINSURE].[ETLUSR].[T001POLMAS_KEY_LOG] WITH (NOLOCK)
    WHERE [DATE] >= '2025-10-14 14:16:16'
        AND FIRM_CODE IN (2,3)
        AND COMPANY_CODE IN (2,3)
)
SELECT 
    [ACTION], 
    COUNT(*) AS ActionCount
FROM LastActions
WHERE rn = 1  -- Sadece en son action
GROUP BY [ACTION]
ORDER BY [ACTION]