3-Day Rolling Average of Tweets Per User – SQL Window Function Challenge

In this challenge, we calculate the 3-day rolling average of tweets per user using SQL. This problem, similar to Problem #10 from the SQL chapter of "Ace the Data Science Interview", tests your ability to use window functions and date-based filtering in time-series data. 🔍 Key Concepts: Window Functions (AVG() with OVER) RANGE or ROWS for window frames Handling time-series rolling aggregates Grouping by user