Verified Pages

Challenge brief

Understand the request

Creator Partnerships is reaching out to verified pages for a co-marketing campaign and needs their contact list.

List verified pages with page name, category, follower count, and creator username.

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

SELECT p.page_name, p.category, p.followers_count, u.username AS creator_username FROM pages p INNER JOIN users u ON p.created_by = u.user_id WHERE p.verified = 1 ORDER BY p.followers_count DESC;

Expected result

Use this output to verify values, aliases, ordering, and row count.