Most Liked Post per Author

Return each author's most liked post (id and likes). Order by author.

Table schema

Posts(id INT PRIMARY KEY, author VARCHAR(10), posted_on DATE, likes INT, views INT)

Sample data

id | author | posted_on | likes | views
1 | Ann | 2026-07-01 | 50 | 500
2 | Ann | 2026-07-02 | 10 | 400
3 | Bob | 2026-07-01 | 90 | 300
4 | Cy | 2026-07-03 | 5 | 50
5 | Bob | 2026-07-05 | 60 | 600