Everybody Wants a Bigger Screen

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The peripherals merchandising team is sizing display demand before the next buy and wants to know who keeps coming back to search for monitors. For each user in the search_queries log, count the searches whose term mentions a monitor, matching any capitalization so 'Monitor' and 'MONITOR' still count, and list the heaviest monitor searchers first.

Summary

The search bar never lies about what people actually want.

Practice This Problem

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