Meta
Interview Core Track · Easy · 15 min
Interest Pages Without Followers
The community team wants the page_id values for interest pages that never picked up a follower. Return the page IDs in ascending order.
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a Meta-tagged business scenario.
Approach
Use this track to improve speed, edge-case handling, and accuracy under timed conditions.
Company context
Company labels are directional practice context, not official interview guidance.
The community team wants the page_id values for interest pages that never picked up a follower. Return the page IDs in ascending order.
interest_pages
| page_id | page_name |
|---|---|
| 1 | Travel |
| 2 | Cooking |
| 3 | Fitness |
| 4 | Finance |
page_follows
| follow_id | user_id | page_id |
|---|---|---|
| 10 | 1001 | 1 |
| 11 | 1002 | 1 |
| 12 | 1003 | 3 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.