SELECT id, stats[offset(0)].total_rides, mv.service_area FROM `reby-cloud.analytics_reby_v1_eu.pg_users_json` u left join `reby-cloud.reby_marketing_eu.users_servicearea_first_mv_ride` mv on u.id = mv.user_id where date(created_at) = current_date -2 order by 2 desc ;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter