Write a SQL query to calculate the rolling 7-day active user count for each day from a table of user activity logs.
