Diminishing Returns

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

A thin result set may change how often shoppers click a result. Split every search into three result-set sizes: none, a small set of one to three, and anything larger, then report each size's click-through rate as a percentage rounded to two decimals, from the highest rate down.

Summary

When search comes back thin, does the click still follow?

Practice This Problem

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