Cumulative user metrics with a full outer join
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.
MetaCodingNo answer yet. Write the first one; the best answer gets endorsed.