Company SQL Question

Group Activity Ranking

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

Problem Statement

Rank groups by their activity level. Calculate total posts from group members and rank groups. Show group name, member count, total posts, and activity rank.

Relevant Tables

groupsgroup_membersposts

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

Running Totals & Moving AveragesWindow Functions
Conditional Aggregation with CASE & FILTERAggregate Functions & Grouping
ROW_NUMBER, RANK, DENSE_RANKWindow Functions