Learn
Common Metrics
Daily Revenue

At the heart of every company is revenue, and Mineblocks is no exception. For our first KPI we’ll calculate daily revenue.

Instructions

1.

Daily Revenue is simply the sum of money made per day.

To get close to Daily Revenue, we calculate the daily sum of the prices in the purchases table. Complete the query by using the sum function and passing the price column from the purchases table.

select date(created_at), round(sum(/**/), 2) from /**/ group by 1 order by 1;
Folder Icon

Sign up to start coding

Already have an account?