Loading interview...

Active User Penetration Rate

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

Interview Prompt

The product analytics team defines an active user on a given device type as someone whose most recent session on that device is within the last 30 days, who has logged at least 5 sessions, and whose total session time on that device is at least 10 hours (36,000 seconds). For each device type, calculate the penetration rate: the number of active users divided by the total number of users on that device. Include device types where no users meet the active threshold, showing a zero rate. Return the device type and penetration rate.

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