Group and Count in SQL Server 2008
try this:
SELECT DownloadDate, Count(DownloadDate) as TotalDownloadedFROM yourtableGROUP BY DownloadDate
SELECT DownloadDate, COUNT(DownloadDate) [TotalDownloaded]FROM TableNameGROUP BY DownloadDate
Try this sql query:
SELECT DownloadDate,COUNT(FullName) AS TotalDownloadFROM YOURTABLEGROUP BY DownloadDateORDER BY DownloadDate;