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

Problem

For each author in migrations, find their most recent migration by applied date (break ties by the largest migr_id). Return the author, version, and applied timestamp of that migration. Sort alphabetically by author.

Practice This Problem

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