At the heart of every company is revenue, and Mineblocks is no exception. For our first KPI we’ll calculate daily revenue.
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;