How to count number of records per day?

Question

I have a table in a with the following structure:

CustID --- DateAdded ---   396       2012-02-09   396       2012-02-09   396       2012-02-08   396       2012-02-07   396       2012-02-07  396       2012-02-07   396       2012-02-06  396       2012-02-06 

I would like to know how I can count the number of records per day, for the last 7 days in SQL and then return this as an integer.

At present I have the following SQL query written:

SELECT *    FROM Responses  WHERE DateAdded >= dateadd(day, datediff(day, 0, GetDate()) - 7, 0)  RETURN 

However this only returns all entries for the past 7 days. How can I count the records per day for the last 7 days?

Answer 1

select DateAdded, count(CustID) from Responses WHERE DateAdded >=dateadd(day,datediff(day,0,GetDate())- 7,0) GROUP BY DateAdded