Company SQL Question
Content Virality Score
Practice this Meta style SQL interview question with live execution and instant feedback.
Problem Statement
Calculate a virality score for each post based on engagement rate, velocity, and reach. Show post ID, username, content preview, total engagement, engagement rate (engagement per like), virality score, and rank. Use complex calculations with CTEs and window functions.
Relevant Tables
postsusers
SQL Concepts Used in This Question
Strengthen your understanding with these targeted learning topics: