Great! Now that we can convert timestamps to dates, we can count the Orders Per Date. Generally, when we count all records in a table we run a query with the
count function, as follows:
This will treat all rows as a single group, and return one row in the result set - the total count.
To count orders by their dates, we'll use the
count functions and pair them with the
group by clause. Together this will count the records in the table, grouped by date.
For example, to see the user records counted by the date created, we use the
count functions and
group by clause as follows:
select date(created_at), count(1)
group by date(created_at)