Question 1

Compute 7-Day Rolling Average of Unique Post Viewers

Accepted Answer

This is a Data Manipulation (SQL/Python) interview question from TikTok for Data Scientist roles. Practice with our interactive coding console on PracHub.

Question 2

How do I practice SQL interview questions?

Accepted Answer

PracHub provides an interactive SQL console where you can write and test your queries against real database schemas. Get instant feedback and compare your solution with the expected output.