SQLQuokka
Start practicing
QuestionsLearnSandboxFeaturesRoadmapFAQ

Facebook Power Posters

Unsolved

Meta's creator team defines a power poster with two conditions. First, the user averages at least 2 posts per active day, where an active day is a calendar date on which they posted at least once (total posts >= 2 × active days). Second, their posts average at least 150 reactions each. Write an SQL query that returns user_id, total_posts and avg_reactions rounded to 2 decimal places for every power poster. Order the results by avg_reactions descending, then user_id ascending.

SQL Query Editor (Ctrl+Enter to run)
0 characters · Valid
Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments
Asked By:
🏢 Meta

Submission History

Your recent query executions and answer checks

Execution Pipeline:
FROM posts
Full source dataset
20 rows total
Ready. Type a query to see live execution.
Clause: Auto-Sync · AlaSQL Engine