Latest Migration Output per Author

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The release manager wants the latest migration each author shipped. For every author in the migrations table, find their most recent migration by applied date (break ties by the largest migration ID). Return the author, version, and applied timestamp, sorted alphabetically by author.

Summary

Each author's most recent migration output.

Practice This Problem

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