Where do i go wrong here


#1

with daily_revenue as (
select
date(created_at) as dt,
round(sum(price), 2) as rev
from purchases
where refunded_at is null
group by 1
)
daily_players as (
select
date(created_at) as dt,
daily_players as players
from gameplays
group by 1
)

select * from daily_revenue order by dt;


#2

forget to add with daily_players