Weekly Churn Rates

We have a table user_actions that logs every action taken by a user. (user_id, event_id) is the primary key. Each row represents one user action. For users who were active at any point in January 2023, calculate the weekly churn rate for each ISO week (Monday to Sunday) that falls within that month. The week is identified by the Monday date of the ISO week containing event_date. Churn rate for a given week W is defined as: (number of users active in W but not active in the…