gistfile1.txt

SELECT 
    businessDate,
    COUNT(CASE WHEN activityType = 'M' THEN 1 END) AS activityTypeMCount,
    COUNT(CASE WHEN activityType = 'FR' THEN 1 END) AS activityTypeFRCount
FROM (
    SELECT businessDate, activityType
    FROM g1ActivityMessageId WITH (NOLOCK)
    WHERE inputUser LIKE 'KL_%' 
    AND inputUser != 'KL_BATCH'
    AND inputDate IN ('2024-10-28', '2024-10-29')
) AS subquery
GROUP BY businessDate;