Practice Meta SQL Question | Real Coding Interviews

Quick Summary

Filter posts created within a rolling 7-day window.
Calculate reaction counts per post, ensuring posts with zero interactions still count.
Compute and round the mean reaction count grouped by user relationship status.

What This Tests

Common Patterns

Left Join

Aggregation

Date Arithmetic

Groupby

Accepted

23/111

Acceptance Rate20.7%

Test Cases

Input

Output

Expected