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 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.

Summary

Some searches lead to clicks. Most do not.

Practice This Problem

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