Higher Performing Variant

An easy SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain
SQL
Difficulty
easy
Seniority
L3

Interview Prompt

Our experiment readings sit in `ab_results`, one row per metric reading, each tagged with the variant label the client logged. Which variant label has the highest average metric value? Return just that label with its average.

Summary

Control versus treatment. One wins.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write and run your SQL against a real database
  4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision