Meta's creator team wants a single headline row for a slide: how many people use the app, and how many of them actually post?
Show one row with: the number of users, the number of users who logged in at least once, the number who created at least one post, and posters as a percentage of logged-in users.
Expected output
posting_rate_pct rounded to 1 decimalExample of the shape (made-up values):
| users | active_users | posters | posting_rate_pct |
|---|---|---|---|
| 300 | 280 | 230 | 82.1 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.