Great! That query doesn’t take refunds into account. We’ll update the query to exclude refunds.
refunded_at will only have data if the transaction was refunded, and otherwise left
Update our daily revenue query to exclude refunds.
Complete the query by filtering for
select date(created_at), round(sum(price), 2) as daily_rev from purchases where /**/ group by 1 order by 1;