Problem Statement

Create a comprehensive influence dashboard calculating each user's influence based on posts, engagement received, friend network, and content quality. Show username, total posts, avg engagement per post, friend count, influence score, and rank. Use multiple CTEs and complex scoring algorithm.

Relevant Tables