SELECT
SUM(CASE WHEN [Created] >= '2024-01-01' AND [Created] < '2024-02-01' THEN 1 ELSE 0 END) AS [Jan],
SUM(CASE WHEN [Created] >= '2024-02-01' AND [Created] < '2024-03-01' THEN 1 ELSE 0 END) AS [Feb],
SUM(CASE WHEN [Created] >= '2024-03-01' AND [Created] < '2024-04-01' THEN 1 ELSE 0 END) AS [Mar],
SUM(CASE WHEN [Created] >= '2024-04-01' AND [Created] < '2024-05-01' THEN 1 ELSE 0 END) AS [Apr],
SUM(CASE WHEN [Created] >= '2024-05-01' AND [Created] < '2024-06-01' THEN 1 ELSE 0 END) AS [May],
SUM(CASE WHEN [Created] >= '2024-06-01' AND [Created] < '2024-07-01' THEN 1 ELSE 0 END) AS [Jun],
SUM(CASE WHEN [Created] >= '2024-07-01' AND [Created] < '2024-08-01' THEN 1 ELSE 0 END) AS [Jul],
SUM(CASE WHEN [Created] >= '2024-08-01' AND [Created] < '2024-09-01' THEN 1 ELSE 0 END) AS [Aug],
SUM(CASE WHEN [Created] >= '2024-09-01' AND [Created] < '2024-10-01' THEN 1 ELSE 0 END) AS [Sep],
SUM(CASE WHEN [Created] >= '2024-10-01' AND [Created] < '2024-11-01' THEN 1 ELSE 0 END) AS [Oct],
SUM(CASE WHEN [Created] >= '2024-11-01' AND [Created] < '2024-12-01' THEN 1 ELSE 0 END) AS [Nov],
SUM(CASE WHEN [Created] >= '2024-12-01' AND [Created] < '2025-01-01' THEN 1 ELSE 0 END) AS [Dec]
FROM [MyTable]
WHERE [Condition] = true;