SELECT
    Category,
    (SELECT
        COUNT(*)
    FROM
        Table t
    WHERE
        t.Category = g.Category
        AND CAST(t.Date as date) >= (SELECT CAST(MAX(m.Date) as date) FROM Table m)
    )
FROM
    Table g
GROUP BY
    Category