Problem Statement

Analyze correlation between different engagement types (posts, comments, likes, messages, stories). For each active user, calculate engagement across all platforms and identify their primary engagement type. Show username, posts, comments, likes given, messages sent, stories created, primary engagement type, and overall activity rank.

Relevant Tables