NOT ABLE TO PASS 9.2 ARPU EXERCISE? keep getting message select ARPU?


Error: near line 1: near "select": syntax error
select ARPU

with daily_revenue as (
    date(created_at) as dt,
    round(sum(price), 2) as rev
  from purchases
  where refunded_at is null
  group by 1
daily_players as (
    date(created_at) as dt,
    count(distinct user_id) as players
  from gameplays
  group by 1
  daily_revenue.rev / daily_players.players
from daily_revenue
join daily_players using (dt);


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.