Second Fiddle

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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

We measure each content format by how many items registered account holders have published, so an item whose creator has no matching user record does not add to a format's total. Take the format sitting second by that total (include every format tied for second) and return the complete records of all its items, whoever the creator is.

Summary

The spotlight finds number one. The story is in what comes right after.

Practice This Problem

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