DataDrivenDataDriven
LearnPracticeInterviewDiscussDailyJobs

The One That Flew

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain
SQL
Difficulty
medium
Seniority
L3

Problem

The CI/CD team is setting a performance baseline from the fastest build ever recorded, and a build only has a duration once it actually finishes. Surface the date and duration of the shortest completed CI build on record, and if more than one build ties for the shortest, take the earliest one.

Summary

The fastest build ever. When did it happen?

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • SQL Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons