Meta's feed team wants to know which kinds of posts fall flat. A simple signal: posts that never received a single like.
For each post_type, show the number of posts and the percentage of those posts that never received a like (an action of 'like' in post_actions).
Expected output
unliked_pct as a percentage rounded to 1 decimal; any row orderExample of the shape (made-up values):
| post_type | posts | unliked_pct |
|---|---|---|
| poll | 140 | 35.0 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.