FreePro119 ProblemsSQL + Python
SaaS B2B SQL & Python Interview Questions
B2B software companies live by SaaS metrics — MRR, ARR, churn, NRR, LTV, and customer health scores. These SQL and Python challenges are modeled after analytical work at Salesforce, Microsoft, Databricks, Snowflake, HubSpot, Atlassian, Datadog, Workday, ServiceNow, Mixpanel, Amplitude, and more. Build skills in subscription analytics, seat expansion tracking, revenue forecasting, product adoption metrics, and customer success analysis.
Companies working in SaaS B2B
These practice problems are modeled after the kind of data and analytics challenges teams in this industry typically face.
Company names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Difficulty Distribution
Easy
22
18% of problems
Medium
50
42% of problems
Hard
42
35% of problems
Expert
5
4% of problems
What You'll Practice
MRR & ARR calculations
Churn & retention analysis
Net Revenue Retention (NRR)
Seat expansion metrics
Customer health scoring
Product adoption analysis
Revenue forecasting
Sales funnel analytics
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 Problems119 total
01
Admins and Owners With MFA EnabledFree
SQLMedium02Latest Invoice per Subscription (Last 180 Days)Free
SQLMedium03Latest Successful Payment per SubscriptionFree
SQLMedium04Org Top Subscriptions by Latest Invoice (180 Days)Free
SQLHard05Open Invoices Ordered by Soonest Due DateFree
SQLEasy06Invoices Due in the Next 7 DaysFree
SQLMedium07Currently Active Subscriptions (Today)Free
SQLMedium08Standardize User Emails and Extract DomainsFree
SQLEasy09Active Users with MFA and Org Domain (Normalized)Free
SQLMedium10Self-serve plans that include overageFree
SQLEasy11Past‑due invoices for active subscriptionsFree
SQLMedium12Filter Enterprise Active OrganizationsFree
PYTHONMedium13Filter Active OrganizationsFree
PYTHONEasy14Filter Large Active SubscriptionsFree
PYTHONMedium15Subscription Statistics by StatusFree
PYTHONMedium16Subscriptions with Organization and Plan DetailsFree
PYTHONMedium17Cross Join Pricing MatrixFree
PYTHONHard18Unstack Subscription CountsFree
PYTHONMedium19Stack Invoice MetricsFree
PYTHONHard20Shift Previous Invoice AmountFree
PYTHONEasy21Expanding Cumulative PaymentsFree
PYTHONMedium22Invoice Lead and Lag AnalysisFree
PYTHONHard23Parse Invoice Date ComponentsFree
PYTHONEasy24Calculate Organization Age in DaysFree
PYTHONMedium25Invoice Period Length AnalysisFree
PYTHONHard26Extract Email DomainFree
PYTHONMedium27Fill Missing Last LoginFree
PYTHONMedium28Derive User Permission LevelsFree
PYTHONMedium29Subscription Revenue by StatusFree
PYTHONMedium30Active Enterprise OrganizationsPro
SQLEasy31Users Without MFA EnabledPro
SQLEasy32Paid Invoices Over $500Pro
SQLEasy33Active Monthly PlansPro
SQLEasy34Subscriptions With Significant DiscountsPro
SQLMedium35Subscriptions With Organization DetailsPro
SQLEasy36Invoices With Subscription and Organization ContextPro
SQLMedium37Support Tickets With User and Product InfoPro
SQLMedium38Payments With Invoice and Organization DetailsPro
SQLMedium39Products Without Active SubscriptionsPro
SQLMedium40Organizations Without Any Support TicketsPro
SQLHard41Subscription Count by StatusPro
SQLEasy42Total Revenue by Product CategoryPro
SQLMedium43Average CSAT Score by ProductPro
SQLMedium44Total Seats by Organization Size BucketPro
SQLMedium45Top 5 Organizations by Total Invoice AmountPro
SQLHard46Products With High Urgent Ticket RatePro
SQLHard47Rank Organizations by Total Subscription ValuePro
SQLMedium48User Sequence Number Within OrganizationPro
SQLMedium49Monthly Invoice Revenue Running TotalPro
SQLHard50Top Product by Usage per OrganizationPro
SQLHard51Invoice Amount 3-Period Moving AveragePro
SQLHard52Payment Amount Change From PreviousPro
SQLHard53Organization Usage Quartile AnalysisPro
SQLHard54Plans Priced Above Category AveragePro
SQLMedium55Organizations With Active Subscriptions and Support TicketsPro
SQLHard56Latest Subscription per OrganizationPro
SQLHard57Organization Revenue With RankPro
SQLHard58Products Outperforming Average RevenuePro
SQLHard59Subscriptions Starting in Last 90 DaysPro
SQLEasy60Monthly Support Ticket VolumePro
SQLMedium61Average Invoice Processing TimePro
SQLMedium62Overdue Invoices by Aging BucketPro
SQLHard63Tickets With Urgency ClassificationPro
SQLEasy64Organizations With Account Health LabelPro
SQLMedium65Subscription Tier Classification With Revenue SummaryPro
SQLHard66Products With Usage Events or Support TicketsPro
SQLMedium67Organizations With Subscriptions But No Support TicketsPro
SQLMedium68Organization Health ScorecardPro
SQLHard69Subscription Renewal Risk AssessmentPro
SQLHard70Payment Collection Funnel by MethodPro
SQLHard71Support Quality Dashboard by ProductPro
SQLHard72Customer 360 SummaryPro
SQLExpert73Revenue Leakage AnalysisPro
SQLHard74Seat Utilization vs Billing ReportPro
SQLHard75Active Organization ProfilesPro
PYTHONEasy76Product Category CountsPro
PYTHONEasy77User Role SummaryPro
PYTHONMedium78Plan Billing Period OverviewPro
PYTHONMedium79Enterprise Active OrganizationsPro
PYTHONEasy80High-Priority Open TicketsPro
PYTHONEasy81Large-Seat Active SubscriptionsPro
PYTHONMedium82Users Without Recent LoginPro
PYTHONMedium83Count Subscriptions by StatusPro
PYTHONEasy84Total Usage by MetricPro
PYTHONMedium85Average Ticket Response Time by PriorityPro
PYTHONMedium86Invoice Statistics by StatusPro
PYTHONHard87Organization Subscription SummaryPro
PYTHONHard88Subscriptions With Organization NamesPro
PYTHONEasy89Tickets With Product DetailsPro
PYTHONMedium90Products Without Active SubscriptionsPro
PYTHONMedium91Invoice With Payment DetailsPro
PYTHONHard92Subscription Full HierarchyPro
PYTHONHard93Rank Organizations by Total UsagePro
PYTHONMedium94Cumulative Invoice Totals per SubscriptionPro
PYTHONMedium957-Day Rolling Average Usage per OrgPro
PYTHONHard96Usage Change vs Previous Day per OrgPro
PYTHONHard97Extract Subscription Start Month and YearPro
PYTHONEasy98Subscription Duration in DaysPro
PYTHONMedium99Monthly Usage Volume by MetricPro
PYTHONHard100Fill Missing Subscription End DatesPro
PYTHONEasy101Normalize Invoice Amounts to DollarsPro
PYTHONMedium102Standardize Ticket Priority LevelsPro
PYTHONHard103Pivot Usage Quantities by Org and MetricPro
PYTHONMedium104Ticket Priority by Channel PivotPro
PYTHONHard105Classify Organizations by Size TierPro
PYTHONMedium106Subscription Health ScorePro
PYTHONHard107Compute Seat Utilization per SubscriptionPro
PYTHONMedium108Invoice Amount Quartile BucketingPro
PYTHONHard109Time-Based Usage FeaturesPro
PYTHONHard110Organization Feature MatrixPro
PYTHONExpert111Ticket Resolution Feature EngineeringPro
PYTHONHard112Invoice Amount Descriptive StatisticsPro
PYTHONMedium113Usage vs Invoice Amount CorrelationPro
PYTHONHard114Anomalous Usage Detection (IQR)Pro
PYTHONHard115Organization Health ScorecardPro
PYTHONHard116Churn Risk Assessment ReportPro
PYTHONHard117Revenue Pipeline AnalysisPro
PYTHONExpert118Customer Success DashboardPro
PYTHONExpert119End-to-End Subscription Lifecycle ReportPro
PYTHONExpertReady to practice SaaS B2B?
119 SQL and Python challenges built from real saas b2b data. Graded instantly in your browser — no setup required.