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


#1


https://www.codecademy.com/en/courses/sql-analyzing-business-metrics/lessons/common-metrics/exercises/arpu-iii?action=resume


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



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,
    count(distinct user_id) as players
  from gameplays
  group by 1
),
select
  daily_revenue.dt,
  daily_revenue.rev / daily_players.players
from daily_revenue
join daily_players using (dt);


#2

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