Twitter SQL Interview Question | Three Days Rolling Average | using Window Function & Self Join

[@DatacraftingWithSneha]

Please like and subscribe for more interesting SQL interview questions and answers.🙏

[@harshitsalecha221]

SELECT user_id,
tweet_date,
ROUND(AVG(tweet_count) OVER(PARTITION BY user_id ORDER BY tweet_date ROWS BETWEEN 2 Preceding AND 0 following),2) as average_3_day_rolling
FROM tweet_data;

[@avinash7003]

Git Repo?

[@DatacraftingWithSneha]

I provided the SQL script in the description.