Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Advanced Aggregates

Daily Count 2

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:

select count(1) from users;

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 date and 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 date and count functions and group by clause as follows:

select date(created_at), count(1) from users group by date(created_at)
Report a Bug
If you see a bug or any other issue with this page, please report it here.