company sql set
Meta
Meta
SQL Set
Posts, friends, feeds, ads, reactions, campaigns, user types, and content engagement.
question list
Work through all 10 questions
Open a problem, write the query, check the expected output, then come back for the next rep.
Q01
Post Engagement Rate
Count engagement per post.
Q02
Active Friends Count
Find users with more than three friends.
Q03
Feed Ranking
Rank posts by engagement.
Q04
Ad Click-Through Rate
Calculate CTR per ad.
Q05
Most Engaged User
Find user with highest engagement.
Q06
Consecutive Login Days
Detect three-day login streaks.
Q07
Viral Posts
Find posts with many reactions.
Q08
Ad Revenue by Campaign
Sum revenue by campaign.
Q09
New vs Returning Users
Classify users by activity.
Q10
Most Popular Content Type
Rank content types by reactions.