# Latest Migration Output per Author

> Each author's most recent migration output.

Canonical URL: <https://datadriven.io/problems/latest_migration_per_author>

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.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/latest_migration_per_author)
- [SQL Interview Questions](https://datadriven.io/sql-interview-questions)
- [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep)
- [Daily Challenge](https://datadriven.io/daily)

---

Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.