SQL Practice Logo

SQLPractice Online

Company SQL Question

Group Activity Ranking

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

Problem Statement

Show each group with its member count, total member posts, and an activity rank using a window function.

Relevant Tables

groupsgroup_membersposts

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: