Content Page Spreads

A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

Picture the content library as a book where each spread places an even-numbered content_id on the left page facing the content_id one higher, an odd number, on the right. Return each spread's left ID, left title, and right title, keeping any page whose facing side is missing with that side left blank.

Summary

Content, laid out in two columns.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.