SELECT
CAST([Created] AS DATE) AS [Date],
COUNT(*) AS [TotalCount]
FROM [MyTable]
WHERE [Created] >= '2024-01-01'
AND [Created] < '2025-01-01'
GROUP BY CAST([Created] AS DATE)
ORDER BY [TotalCount] DESC;
SELECT
CAST([Created] AS DATE) AS [Date],
COUNT(*) AS [TotalCount]
FROM [MyTable]
WHERE [Created] >= '2024-01-01'
AND [Created] < '2025-01-01'
GROUP BY CAST([Created] AS DATE)
ORDER BY [TotalCount] DESC;