SQL Practice Logo

SQLPractice Online

Company SQL Question

Content Virality Score

Practice this Meta style SQL interview question with live execution and instant feedback.

Problem Statement

Compute weighted engagement and a 0-100 normalised virality score per post using two CTEs and RANK().

Relevant Tables

postsusers

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: