Practice SQL Question | Real Coding Interviews | Hack2hire

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

Question Bank Pricing Blog Forum

Quick Summary

Identify pages that exist in the catalog but have no corresponding records in the likes table.
Requires an anti-join pattern or set subtraction to filter out pages with activity.
The final result must be ordered by page ID in ascending sequence.

What This Tests

Implementing an anti-join to find unmatched records across tables.
Understanding how outer joins preserve rows from the driving table.
Using null checks or set operations to detect missing relationships.
Applying sorting constraints to the output dataset.

Common Patterns

Left Join

Subquery

Sort

Merge

Test Cases

Input

-

Output

-

Expected

-