Practice Meta SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Compute average reactions per post within a fixed seven-day window.
Include posts with zero interactions so they correctly factor into the average.
Group by relationship, round to two decimals, and sort alphabetically.

What This Tests

Multi-step aggregation (counting per entity before averaging)
Outer join semantics for preserving zero-count records
Date range filtering
Metric rounding and ordering

Common Patterns

Left Join

Aggregation

Groupby

Accepted

34/172

Acceptance Rate19.8%

Test Cases

Input

-

Output

-

Expected

-