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

Domain

SQL

Difficulty

hard

Problem

The search team is comparing search success between brand-new and tenured users. A user counts as 'new' if their signup is within 30 days of the most recent signup on file; everyone else is 'existing'. A search counts as successful when the user clicked through to a result. For each segment, show the segment label, total searches, successful searches, and the success rate as a decimal. Sort alphabetically by segment.

Summary

New users versus existing. The upvote gap.

Practice This Problem

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