FreePro129 ProblemsSQL + Python
Social Graph SQL & Python Interview Questions
Social networks process engagement at massive scale — posts, likes, follows, shares, and content interactions. These SQL and Python challenges are modeled after work at Meta, LinkedIn, TikTok, Snap, Twitter/X, Reddit, Pinterest, YouTube, Discord, Twitch, and more. Master network effects analysis, viral coefficients, content ranking signals, creator monetization, feed algorithm metrics, and user engagement funnels.
Top Companies Hiring in Social Graph
Questions are relevant for real analytics problems data science teams solve at these companies.
Difficulty Distribution
Easy
25
19% of problems
Medium
53
41% of problems
Hard
42
33% of problems
Expert
9
7% of problems
What You'll Practice
Engagement rate analysis
Network effect metrics
Viral coefficient calculation
Content performance
Creator monetization
Feed algorithm signals
User retention analysis
Growth accounting
Topics Covered
SQL· 9
aggregationbasic queries filteringcleaning transformdate timejoinsscenario sqlset operationssubqueries cteswindow functions
Python· 12
eda statisticsfeature engineeringpandas aggregationpandas applypandas basicspandas cleaningpandas datetimepandas filteringpandas mergingpandas reshapingpandas scenariopandas window
All Problems129 total
01
Public Link PostsFree
SQLEasy02Recent Non-Deleted Direct MessagesFree
SQLMedium03Two Most Recent Posts per UserFree
SQLMedium04Latest Reaction per PostFree
SQLMedium05Latest Message per Sender–Recipient PairFree
SQLMedium06Message Intervals per Sender — Last 60 DaysFree
SQLHard07Most Recent Direct Messages (Newest First)Free
SQLEasy08Verified Users’ Posts in the Last 14 DaysFree
SQLMedium09Published Posts from Verified Users (Normalized)Free
SQLMedium10Users Who Posted or CommentedFree
SQLMedium11Verified Active AccountsFree
SQLEasy12Filter Public PostsFree
PYTHONEasy13Filter Verified Active UsersFree
PYTHONMedium14Filter Public PostsFree
PYTHONEasy15Filter Visual or Public PostsFree
PYTHONMedium16Filter Verified Non-Suspended UsersFree
PYTHONHard17Posts by Type and VisibilityFree
PYTHONMedium18Concat Posts and CommentsFree
PYTHONEasy19Posts with User DetailsFree
PYTHONMedium20Merge with Different Column NamesFree
PYTHONMedium21Concat with Missing ColumnsFree
PYTHONMedium22Followers with Following NamesFree
PYTHONHard23Users Without Recent PostsFree
PYTHONHard24Pivot Posts by Type and VisibilityFree
PYTHONMedium25Pivot Users by Country and StatusFree
PYTHONMedium26Rank Posts per UserFree
PYTHONMedium27Get Previous Post per UserFree
PYTHONMedium28Cumulative User Sign-up PercentageFree
PYTHONHard29Extract Day of Week from PostsFree
PYTHONEasy30Filter Posts by Specific MonthFree
PYTHONMedium31User Post Timing AnalysisFree
PYTHONHard32Fill Missing User BiosFree
PYTHONEasy33Lowercase UsernamesFree
PYTHONEasy34Drop Users Missing Contact InfoFree
PYTHONMedium35Clean User Posts for AnalysisFree
PYTHONHard36Format Display NamesFree
PYTHONMedium37Calculate Post Engagement ScoreFree
PYTHONHard38Published Content SummaryFree
PYTHONEasy39Creator Engagement MetricsFree
PYTHONMedium40Active Verified UsersPro
SQLEasy41Public Published PostsPro
SQLEasy42Open Moderation ReportsPro
SQLEasy43Active Users in Target CountriesPro
SQLMedium44Read Messages in Date RangePro
SQLMedium45Posts with Author UsernamePro
SQLEasy46Comments with Post Type and CommenterPro
SQLMedium47Active Group Members with DetailsPro
SQLMedium48Follower-Followee UsernamesPro
SQLMedium49Users Who Never PostedPro
SQLHard50Published Posts Without ReactionsPro
SQLHard51Post Count by Content TypePro
SQLEasy52Reaction Count by Type for PostsPro
SQLMedium53Users With More Than Five FollowersPro
SQLMedium54Average Comments per Post by VisibilityPro
SQLMedium55Top Five Most Active CommentersPro
SQLHard56Group Membership Role BreakdownPro
SQLHard57Rank Users by Follower CountPro
SQLMedium58Number Posts per User ChronologicallyPro
SQLMedium59Running Total of Daily New PostsPro
SQLHard60Top Post by Reactions per UserPro
SQLHard61Monthly Comment Moving AveragePro
SQLHard62Time Gap Between Consecutive MessagesPro
SQLHard63User Engagement Quartile AnalysisPro
SQLExpert64Public Posts Above Average ReactionsPro
SQLMedium65Mutual Follow PairsPro
SQLHard66Most Recent Post Per UserPro
SQLHard67Multi-Group Users with Group DetailsPro
SQLHard68User Engagement Score PipelinePro
SQLExpert69Users Who Joined in 2024Pro
SQLEasy70Monthly Post Volume by VisibilityPro
SQLMedium71Average Moderation Report Resolution TimePro
SQLMedium72User Tenure vs Post ActivityPro
SQLHard73Message Delivery Status LabelsPro
SQLEasy74User Engagement Tier ClassificationPro
SQLMedium75Content Moderation Risk ScorePro
SQLHard76Content Contributors UnionPro
SQLMedium77Private Users Without Public PostsPro
SQLMedium78User Influence ScorecardPro
SQLHard79Content Virality ReportPro
SQLHard80Group Health DashboardPro
SQLHard81Moderation Workload AnalysisPro
SQLHard82Platform Trust and Safety ReportPro
SQLExpert83Social Network Connectivity AnalysisPro
SQLExpert84Complete User Engagement DashboardPro
SQLExpert85Active User ProfilesPro
PYTHONEasy86Post Content Type CountsPro
PYTHONEasy87Reaction Type SummaryPro
PYTHONMedium88Group Privacy OverviewPro
PYTHONMedium89Verified Active UsersPro
PYTHONEasy90Public Published PostsPro
PYTHONEasy91High-Engagement Post ReactionsPro
PYTHONMedium92Unread Messages by RecipientPro
PYTHONMedium93Count Posts by Content TypePro
PYTHONEasy94Comment Count per PostPro
PYTHONMedium95Reactions by Type and EntityPro
PYTHONMedium96Group Membership StatisticsPro
PYTHONHard97User Engagement SummaryPro
PYTHONHard98Posts With Author NamesPro
PYTHONEasy99Comments With Post DetailsPro
PYTHONMedium100Users Without PostsPro
PYTHONMedium101Follower Details With User InfoPro
PYTHONHard102Post Full Engagement DetailsPro
PYTHONHard103Rank Users by Post CountPro
PYTHONMedium104Cumulative Reactions per UserPro
PYTHONMedium1057-Day Rolling Average Posts per UserPro
PYTHONHard106Daily Comment Change vs Previous DayPro
PYTHONHard107Extract User Join Month and YearPro
PYTHONEasy108Account Age in DaysPro
PYTHONMedium109Monthly Post Volume by Content TypePro
PYTHONHard110Fill Missing User BiosPro
PYTHONEasy111Normalize Reaction Types to CategoriesPro
PYTHONMedium112Standardize Moderation Report ReasonsPro
PYTHONHard113Pivot Reaction Counts by Entity and TypePro
PYTHONMedium114Moderation Reports by Reason and StatusPro
PYTHONHard115Classify Users by Activity LevelPro
PYTHONMedium116Post Engagement ScorePro
PYTHONHard117Compute Post Engagement RatePro
PYTHONMedium118Reaction Count Quartile BucketingPro
PYTHONHard119Time-Based Post FeaturesPro
PYTHONHard120User Feature MatrixPro
PYTHONExpert121Message Activity Feature EngineeringPro
PYTHONHard122Post Count Descriptive Statistics by UserPro
PYTHONMedium123Posts vs Reactions CorrelationPro
PYTHONHard124Anomalous User Engagement Detection (IQR)Pro
PYTHONHard125User Influence ScorecardPro
PYTHONHard126Content Moderation ReportPro
PYTHONHard127Community Health DashboardPro
PYTHONExpert128User Trust Classification SystemPro
PYTHONExpert129Cross-Platform Engagement AnalysisPro
PYTHONExpertReady to practice Social Graph?
129 SQL and Python challenges built from real social graph data. Graded instantly in your browser — no setup required.