Engagement Rate

Engagement rate = likes / views as a percentage, rounded to 2 decimals. Return the post id and its rate for posts with at least 10% engagement, ordered by rate descending.

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