Click vs Non-Click Rates

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

Domain

SQL

Difficulty

medium

Seniority

mid

Problem

The search quality team wants to measure how often users click a result when the result set is small. In a single row, compute two percentages relative to all search records: the share of queries where a result was clicked and the results count was 3 or fewer, and the share where no result was clicked despite the results count being 3 or fewer.

Practice This Problem

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