Loading interview...

Email Census

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

Domain
SQL
Difficulty
easy

Interview Prompt

The CRM team is sizing their outreach lists before the next campaign. Segment every user account into one of two groups: those with an email address on file and those without. For each segment, show how many users fall into each bucket and what share of all users that segment represents, expressed as a percentage rounded to one decimal place. List the larger segment first.

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