How did I do?*

Query number of records created on each day in SQL Server

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;