Given two tables containing user login events and subscription tiers, write a SQL query to find the week-over-week retention rate for premium users.
