First and Last Peak Accuracy Dates

A medium 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
medium
Seniority
L3

Interview Prompt

Every training run lands in `ml_models` with its accuracy, and we want to know when our best-ever accuracy was first reached and whether any run has matched it since. Show the earliest and latest training dates among the runs that hit that top score.

Summary

Peak accuracy. When it first hit and when it last did.

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