DataDriven
LearnPracticeInterviewDiscussDailyJobs

Repeat Buyers Across Halves

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

Domain
SQL
Difficulty
medium
Seniority
L4

Interview Prompt

Find users who made at least 1 transaction in both the first half (Jan through Jun) and second half (Jul through Dec) of 2025. Return the user ID.

Summary

First half buyer. Second half buyer. Same person.

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

Related

  • All Mock Interviews
  • Practice Mode (untimed)
  • SQL Interview Questions
  • Data Engineering Interview Prep Guide
  • Practice Problems
  • Daily Challenge