Skip to content
Advertisement

How to count number of records per day?

I have a table in a with the following structure:

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:

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

Advertisement

Answer

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement