Posts per Author

Return each author and the number of posts, highest first.

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