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.
Loading…
Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.
Ask questions, share alternate queries, and explore solutions
Your recent query executions and answer checks
This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.