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

Transform asymmetric friendship records into bidirectional user-friend pairs.
Match friends' event RSVPs against a future date threshold.
Exclude already-attended events and ensure unique recommendation pairs.

What This Tests

Handling bidirectional relationships in relational data
Joining multiple tables with conditional filters
Excluding existing records using anti-join logic
Deduplicating and ordering result sets

Common Patterns

Union

Inner Join

Subquery

Deduplication

Test Cases

Input

-

Output

-

Expected

-