A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Problem
We ran a search quality audit and need to find users whose search terms contain 'desk', 'monitor', 'cable', or 'mouse' in singular form only. Exclude any entries that use the plural forms of those words. Return unique user IDs only.
Summary
The search terms reveal intent.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.