Loading interview...

Funnel Leakage Report

A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
hard
Seniority
senior, staff

Interview Prompt

Given a event_data table with user_id, event_type, and tags, write a query to build a conversion funnel. Events progress through: page_view, add_to_cart, checkout_start, purchase. For each step, show the count of unique users who reached it and the drop-off percentage from the prior step. Break down by device type.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision