Least Viewed Content

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The content team is pruning dead pages, where each page_url is already stored in its final canonical form and should be treated exactly as recorded. Find the content with the fewest unique viewers, counting a visitor who returns to the same page many times only once. If several pages share that lowest viewer count, include all of them.

Summary

Nobody is watching. Should it still exist?

Practice This Problem

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