← Questions
Cumulative user metrics with a full outer join
0
I was asked this
No reports yet. Sign in to say where you were asked it.
Maintain a cumulative table of per-user metrics day by day: combine yesterday's cumulative snapshot with today's activity using a full outer join, so users with no activity today keep their totals and new users appear. Write the SQL and explain how the job reruns safely.
No official answer yet. Write yours on the right and run it.
Nothing published yet.
Sign in to submit your code; every attempt is kept here.
Write and test your solution herePython in your browser, the question's tests level by level, every submission kept for you.Sign in to start coding