Practice Meta SQL Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

Quick Summary

Count posts where the relationship is marked as 'unrelated'.
Restrict results to a fixed seven-day window from 2026-06-17 to 2026-06-24 inclusive.
Return the total count as a single column named 'unrelated_count'.

What This Tests

Filtering rows based on exact string matches.
Evaluating date ranges with inclusive boundaries.
Using scalar aggregation functions.

Common Patterns

Aggregation

Test Cases

Input

-

Output

-

Expected

-