Browse by SQL concept

Drill the exact topic you want to practice

Every mission on caseSQL is tagged with the SQL concepts it practices. Pick a concept below to see every mission that drills it — across all four career paths. Great for targeted practice before an interview, or when you want to shore up a weak spot.

541 concepts · 580 missions

GROUP BY83 missions
Marketing·StarterWhere are our customers?Mission 4 →Marketing·StarterWhat are people buying?Mission 5 →Marketing·EasyWhich coupon is pulling its weight?Mission 7 →Marketing·MediumWhat's our average order value per campaign?Mission 15 →Provider·StarterEncounters by departmentMission 4 →Provider·StarterInsurance mixMission 5 →Provider·EasyTop 10 diagnosesMission 7 →Clinical Ops·EasyEncounter diagnosis volume by typeMission 4 →Clinical Ops·EasyThe POA tallyMission 5 →Clinical Ops·MediumTop 10 most-documented codesMission 7 →Clinical Ops·MediumBody system distributionMission 8 →Clinical Ops·MediumTop 10 chronic conditionsMission 9 →Clinical Ops·MasterTranslate the codes — top principal diagnosesMission 21 →Clinical Trials·EasyActive trials by phaseMission 1 →Clinical Trials·EasyWithdrawal reasons breakdownMission 3 →Clinical Trials·EasyAdverse events by severity gradeMission 5 →Clinical Trials·MediumPhase-3 trial rosterMission 8 →Payer Claims·EasyActive members by plan_typeMission 1 →Payer Claims·EasyClaims volume by service monthMission 2 →Payer Claims·EasyTop 5 specialties by claim countMission 3 →Payer Claims·MediumFirst-pass appeal volume by levelMission 10 →Pharma Commercial·EasyRx fills per productMission 3 →Pharma Commercial·EasyCalls per repMission 4 →Pharma Commercial·EasyPayer mix — Rx count per plan_typeMission 5 →Pharma Commercial·MediumTop 10 prescribers by Rx volumeMission 6 →Pharma Commercial·MediumTerritory roster — HCPs per territoryMission 9 →Hospital RCM·EasyActive payers by plan typeMission 1 →Hospital RCM·EasyCharges per CPT codeMission 3 →Hospital RCM·EasyClaims submitted per payerMission 4 →Hospital RCM·EasyTotal payments per providerMission 5 →Hospital RCM·MediumAR aging bucketsMission 10 →Hospital RCM·HardDays-in-AR by payer — open claims agingMission 11 →Finance·EasyTop 10 vendors — YTD spendMission 7 →Finance·EasyDepartmental spend by monthMission 9 →Finance·MediumRevenue seasonality by monthMission 13 →Banking·StarterActive deposit customers by stateMission 4 →Banking·EasyFICO band distribution at originationMission 8 →Banking·MediumVintage originations pacingMission 12 →AML & Fraud·StarterActive customers by stateMission 3 →AML & Fraud·EasySub-$10K cash deposits by customerMission 6 →AML & Fraud·EasyDaily deposit count per accountMission 7 →AML & Fraud·MediumRound-dollar wires — flag a patternMission 11 →Retail Banking Operations·StarterActive deposit customers by stateMission 4 →Retail Banking Operations·EasyBranch 13 missing transactionsMission 6 →Consumer Lending Analyst·StarterApplications by stateMission 4 →Consumer Lending Analyst·EasyAvg funded amount by loan purposeMission 7 →Consumer Lending Analyst·EasyHMDA action_taken distributionMission 8 →Consumer Lending Analyst·EasyOriginations by LO (top 10)Mission 10 →RevOps·StarterOpen opportunities by ownerMission 3 →RevOps·EasyPipeline value by stageMission 6 →RevOps·EasyDeals by close quarterMission 7 →RevOps·EasyAverage deal size by regionMission 9 →RevOps·MediumQuota attainment by rep (2025-Q1)Mission 31 →E-commerce·StarterCustomers by countryMission 3 →E-commerce·EasyRevenue by financial statusMission 6 →E-commerce·EasyOrders by monthMission 7 →E-commerce·EasyAverage order value by channelMission 9 →E-commerce·MediumTop 10 products by units soldMission 11 →Operations·EasyTotal units ordered per category last quarterMission 6 →Operations·MediumLatest inventory on hand per warehouseMission 12 →Operations·MediumLead-time consistency per supplierMission 14 →Logistics & Transportation Analytics·StarterStatus breakdownMission 5 →Logistics & Transportation Analytics·EasyCarrier shipment volumeMission 6 →Logistics & Transportation Analytics·EasyAverage freight cost per modeMission 10 →Logistics & Transportation Analytics·MediumDetention hot spots — lanes with high dwellMission 12 →Logistics & Transportation Analytics·MediumDuplicate tracking eventsMission 17 →Logistics & Transportation Analytics·HardMonthly freight cost trend by carrier modeMission 19 →Logistics & Transportation Analytics·HardLane-level OTD with carrier namesMission 20 →Logistics & Transportation Analytics·ExpertCarrier scorecard — four metrics in one queryMission 24 →Logistics & Transportation Analytics·MediumRegional origin performance — cost and OTDMission 26 →Procurement & Sourcing Analytics·EasySpend by categoryMission 6 →Procurement & Sourcing Analytics·EasySupplier PO volumeMission 7 →Procurement & Sourcing Analytics·MediumTop 10 suppliers by spendMission 11 →Procurement & Sourcing Analytics·MediumPreferred vs non-preferred shareMission 13 →Procurement & Sourcing Analytics·MasterCategory x spend-type cubeMission 26 →Warehouse Operations Analytics·EasySKUs by velocity classMission 6 →Warehouse Operations Analytics·EasyUPLH by zoneMission 7 →Warehouse Operations Analytics·EasyTop SKUs by pick frequencyMission 8 →Warehouse Operations Analytics·EasyInbound by day of weekMission 9 →Warehouse Operations Analytics·MediumPick rate by zone and shiftMission 12 →Warehouse Operations Analytics·HardLabor by functionMission 18 →Demand Planning & Forecasting Analytics·StarterSKUs by lifecycleMission 1 →Demand Planning & Forecasting Analytics·HardABC x XYZ segmentationMission 20 →
ORDER BY51 missions
Marketing·StarterWhere are our customers?Mission 4 →Provider·StarterEncounters by departmentMission 4 →Clinical Ops·EasyBrowse the cardiology codebookMission 1 →Clinical Ops·EasyPull the chronic disease listMission 2 →Clinical Ops·MediumTranslate every diagnosis on the chartMission 6 →Payer Claims·EasyClaims volume by service monthMission 2 →Payer Claims·EasyOut-of-network provider listMission 4 →Payer Claims·MediumCARC code frequency × categoryMission 8 →Pharma Commercial·EasyActive products by therapeutic classMission 1 →Pharma Commercial·EasyHCPs in cardiology specialtyMission 2 →Pharma Commercial·EasyCalls per repMission 4 →Pharma Commercial·MediumTerritory roster — HCPs per territoryMission 9 →Hospital RCM·EasyMedicare patients by demographicMission 2 →Finance·EasyTop 10 vendors — YTD spendMission 7 →Banking·StarterActive deposit customers by stateMission 4 →Consumer Lending Analyst·StarterLoan product taxonomyMission 2 →Consumer Lending Analyst·EasyOriginations by LO (top 10)Mission 10 →RevOps·StarterDeals over $50K by accountMission 5 →E-commerce·StarterOrders over $200 by customerMission 5 →E-commerce·MediumTop 10 products by units soldMission 11 →Operations·EasyTop 5 SKUs by purchase valueMission 8 →Logistics & Transportation Analytics·StarterMeet the carrier networkMission 2 →Logistics & Transportation Analytics·StarterLane inventoryMission 3 →Logistics & Transportation Analytics·StarterStatus breakdownMission 5 →Logistics & Transportation Analytics·MediumOn-time delivery rate by carrierMission 8 →Logistics & Transportation Analytics·MediumIn-full rate by carrierMission 9 →Logistics & Transportation Analytics·EasyAverage freight cost per modeMission 10 →Logistics & Transportation Analytics·MediumDetention hot spots — lanes with high dwellMission 12 →Logistics & Transportation Analytics·MediumTop 5 most expensive shipmentsMission 13 →Logistics & Transportation Analytics·MediumCarrier spend with invoice dataMission 15 →Logistics & Transportation Analytics·HardCarrier OTD vs. target gapMission 18 →Logistics & Transportation Analytics·HardMonthly freight cost trend by carrier modeMission 19 →Logistics & Transportation Analytics·ExpertInvoice audit: billed vs shipped amountsMission 23 →Logistics & Transportation Analytics·EasyTracking event timeline for a shipmentMission 25 →Logistics & Transportation Analytics·MediumRegional origin performance — cost and OTDMission 26 →Logistics & Transportation Analytics·MediumShipments with accessorial charges — detention deep diveMission 27 →Logistics & Transportation Analytics·MasterEnd-to-end carrier risk indexMission 30 →Procurement & Sourcing Analytics·StarterCategory catalogMission 2 →Procurement & Sourcing Analytics·StarterTop 10 invoices by amountMission 5 →Procurement & Sourcing Analytics·EasySupplier PO volumeMission 7 →Procurement & Sourcing Analytics·EasyOn-time delivery per supplierMission 8 →Procurement & Sourcing Analytics·MediumTop 10 suppliers by spendMission 11 →Procurement & Sourcing Analytics·HardContract compliance rateMission 18 →Procurement & Sourcing Analytics·MasterSupplier risk scoreMission 29 →Procurement & Sourcing Analytics·MasterProcurement capstoneMission 30 →Warehouse Operations Analytics·StarterWorker rosterMission 2 →Warehouse Operations Analytics·StarterInventory snapshot top 10Mission 4 →Warehouse Operations Analytics·MediumPick rate by zone and shiftMission 12 →Warehouse Operations Analytics·MasterOperations scorecardMission 29 →Demand Planning & Forecasting Analytics·StarterForecast versionsMission 3 →Demand Planning & Forecasting Analytics·StarterPromo calendarMission 5 →
WHERE46 missions
Marketing·EasyWhich coupon is pulling its weight?Mission 7 →Provider·EasyED wait time overviewMission 8 →Provider·EasyProvider roster with red flagsMission 10 →Finance·Starter2025 SaaS spend totalMission 4 →Finance·EasyUn-posted journal auditMission 8 →Banking·StarterOpen accounts right nowMission 3 →Banking·EasyReversals and chargebacks — clean the spend totalMission 6 →Banking·MediumStructuring flag — sub-$10K cash depositsMission 14 →AML & Fraud·StarterActive customers by stateMission 3 →AML & Fraud·StarterDrop the reversalsMission 4 →AML & Fraud·StarterCash deposits over $10KMission 5 →AML & Fraud·MediumRound-dollar wires — flag a patternMission 11 →AML & Fraud·MediumStructuring candidates — $9K–$9,999 over 14 daysMission 13 →AML & Fraud·HardFalse positives by rule — tuning targetsMission 19 →Retail Banking Operations·StarterNet new checking accounts this weekMission 5 →Consumer Lending Analyst·StarterLoan product taxonomyMission 2 →Consumer Lending Analyst·StarterFunded originations this quarterMission 3 →Consumer Lending Analyst·StarterNet new mortgages last 30 daysMission 5 →Consumer Lending Analyst·Easy30+ delinquent loan countMission 9 →RevOps·StarterOpen opportunities by ownerMission 3 →RevOps·StarterDrop the Closed-Lost dealsMission 4 →RevOps·StarterDeals over $50K by accountMission 5 →E-commerce·StarterDrop the voided / refunded ordersMission 4 →E-commerce·StarterOrders over $200 by customerMission 5 →Logistics & Transportation Analytics·StarterLane inventoryMission 3 →Logistics & Transportation Analytics·StarterDelivered shipment countMission 4 →Logistics & Transportation Analytics·MediumOverbilled invoicesMission 14 →Logistics & Transportation Analytics·MediumFailed shipments with carrier detailMission 16 →Logistics & Transportation Analytics·ExpertWeight-normalized freight cost per mileMission 22 →Logistics & Transportation Analytics·EasyTracking event timeline for a shipmentMission 25 →Logistics & Transportation Analytics·MediumShipments with accessorial charges — detention deep diveMission 27 →Logistics & Transportation Analytics·MasterShipment delivery delay analysisMission 28 →Procurement & Sourcing Analytics·StarterOpen POs countMission 3 →Procurement & Sourcing Analytics·StarterActive contract countMission 4 →Procurement & Sourcing Analytics·EasyATF detectionMission 10 →Procurement & Sourcing Analytics·MediumPurchase price varianceMission 15 →Procurement & Sourcing Analytics·Hard3-way matchMission 16 →Procurement & Sourcing Analytics·ExpertApex supplier dedupMission 24 →Warehouse Operations Analytics·HardSLA breachesMission 17 →Warehouse Operations Analytics·ExpertCycle count $$$ triageMission 22 →Warehouse Operations Analytics·ExpertWave failure analysisMission 25 →Warehouse Operations Analytics·MasterSlotting recommendationMission 26 →Demand Planning & Forecasting Analytics·StarterRecent actualsMission 4 →Demand Planning & Forecasting Analytics·MediumIntermittent SKU detectionMission 12 →Demand Planning & Forecasting Analytics·ExpertPersistent bias by SKUMission 21 →Demand Planning & Forecasting Analytics·MasterDemand-supply gapMission 28 →
Multi-CTE42 missions
Clinical Trials·ExpertAE attribution matrix — intervention × severityMission 16 →Clinical Trials·ExpertSite HHI — concentration of enrollments per therapeutic areaMission 18 →Payer Claims·HardTop denial concentration via HHI on CARC codesMission 12 →Payer Claims·ExpertOverturn% by level × denial_category (MAX(CASE) pivot)Mission 16 →Payer Claims·MasterRecoverable revenue at historical overturn rateMission 22 →Pharma Commercial·ExpertHCP×product call-Rx ROI matrixMission 16 →Pharma Commercial·ExpertTerritory market share HHI — concentration of Rx volumeMission 18 →Pharma Commercial·MasterRep effectiveness — calls vs Rx delta paired pivot, ranked within districtMission 22 →Hospital RCM·HardDays-in-AR by payer — open claims agingMission 11 →Hospital RCM·HardUnderpayment detection — contracted vs paidMission 14 →Hospital RCM·ExpertProvider × CPT productivity matrixMission 16 →Hospital RCM·ExpertAppeal overturn cohort — denied claims that paid after appealMission 17 →Hospital RCM·ExpertPayer concentration HHI per service lineMission 18 →Hospital RCM·MasterProvider effectiveness — charges vs collections delta, ranked within departmentMission 22 →Finance·MasterVariance bridge with allocation overlayMission 26 →AML & Fraud·ExpertRule-tuning backtest — precision quadrantsMission 24 →Retail Banking Operations·ExpertCustomer 360 — top depositorsMission 25 →Consumer Lending Analyst·HardEarly-Payment Default rate by vintage monthMission 16 →Consumer Lending Analyst·HardDelinquency progression: first miss × current statusMission 19 →Consumer Lending Analyst·ExpertPortfolio LTV stratification with seasoningMission 22 →Consumer Lending Analyst·ExpertCharge-off rate + principal recovery by vintage yearMission 24 →Consumer Lending Analyst·MasterFair Lending disparity index by FICO band (Black vs White)Mission 26 →RevOps·HardQuarterly bookings waterfall — new vs expandMission 19 →RevOps·ExpertPipeline hygiene — issue count per opportunityMission 21 →RevOps·ExpertARR bridge — starting + new + expand per quarterMission 22 →RevOps·ExpertRep performance dashboardMission 24 →E-commerce·HardGA4 conversion-value vs Shopify revenueMission 19 →E-commerce·ExpertRFM segmentation — customer scoringMission 21 →E-commerce·ExpertThree-system revenue reconciliationMission 22 →E-commerce·ExpertAbandoned-cart funnel by sourceMission 23 →E-commerce·ExpertDTC growth dashboardMission 24 →Operations·HardSupplier scorecard (lead time + on-time + cancellation)Mission 17 →Operations·MasterSupplier health capstone (multi-CTE scorecard)Mission 26 →Logistics & Transportation Analytics·MasterRolling 3-month freight cost vs prior periodMission 29 →Procurement & Sourcing Analytics·MediumPurchase price varianceMission 15 →Procurement & Sourcing Analytics·HardSpend under management %Mission 19 →Procurement & Sourcing Analytics·MasterDual-source coverageMission 28 →Procurement & Sourcing Analytics·MasterProcurement capstoneMission 30 →Warehouse Operations Analytics·ExpertZone utilizationMission 24 →Warehouse Operations Analytics·MasterPerfect inbound rateMission 28 →Warehouse Operations Analytics·MasterDC capstoneMission 30 →Demand Planning & Forecasting Analytics·MasterDemand planning capstoneMission 30 →
JOIN38 missions
Provider·StarterEncounters by departmentMission 4 →Provider·EasyWho's currently admitted?Mission 6 →Provider·EasyProvider roster with red flagsMission 10 →Clinical Ops·MediumTop 10 most-documented codesMission 7 →Clinical Ops·MediumBody system distributionMission 8 →Clinical Ops·MediumTop 10 chronic conditionsMission 9 →Finance·StarterMarch 2025 expense rollupMission 5 →Banking·StarterActive deposit customers by stateMission 4 →Banking·EasyJoint accounts — who’s the primary?Mission 10 →AML & Fraud·StarterActive customers by stateMission 3 →Retail Banking Operations·StarterActive deposit customers by stateMission 4 →Retail Banking Operations·EasyNSF / OD fee revenue by FICO bandMission 9 →Consumer Lending Analyst·StarterApplications by stateMission 4 →Consumer Lending Analyst·HardARM reset wall (next 6 months)Mission 17 →RevOps·StarterOpen opportunities by ownerMission 3 →RevOps·EasyAverage deal size by regionMission 9 →RevOps·MediumQuota attainment by rep (2025-Q1)Mission 31 →E-commerce·StarterCustomers by countryMission 3 →E-commerce·MediumTop 10 products by units soldMission 11 →E-commerce·MediumSource/medium attribution — last-touchMission 13 →Logistics & Transportation Analytics·EasyCarrier shipment volumeMission 6 →Logistics & Transportation Analytics·MediumOn-time delivery rate by carrierMission 8 →Logistics & Transportation Analytics·EasyAverage freight cost per modeMission 10 →Logistics & Transportation Analytics·MediumCarrier spend with invoice dataMission 15 →Logistics & Transportation Analytics·MediumFailed shipments with carrier detailMission 16 →Logistics & Transportation Analytics·HardCarrier OTD vs. target gapMission 18 →Logistics & Transportation Analytics·HardMonthly freight cost trend by carrier modeMission 19 →Logistics & Transportation Analytics·HardLane-level OTD with carrier namesMission 20 →Logistics & Transportation Analytics·HardPerfect score carriers — OTD and in-full combinedMission 21 →Logistics & Transportation Analytics·ExpertWeight-normalized freight cost per mileMission 22 →Logistics & Transportation Analytics·ExpertInvoice audit: billed vs shipped amountsMission 23 →Logistics & Transportation Analytics·ExpertCarrier scorecard — four metrics in one queryMission 24 →Logistics & Transportation Analytics·MediumRegional origin performance — cost and OTDMission 26 →Logistics & Transportation Analytics·MediumShipments with accessorial charges — detention deep diveMission 27 →Logistics & Transportation Analytics·MasterShipment delivery delay analysisMission 28 →Logistics & Transportation Analytics·MasterEnd-to-end carrier risk indexMission 30 →Procurement & Sourcing Analytics·EasySpend by categoryMission 6 →Warehouse Operations Analytics·HardSlotting mismatchMission 19 →
LIMIT29 missions
Marketing·StarterWelcome — preview the customer tableMission 1 →Marketing·StarterWhere are our customers?Mission 4 →Marketing·MediumTop 5 customers by spendMission 13 →Provider·StarterMeet the patientsMission 1 →Provider·EasyTop 10 diagnosesMission 7 →Clinical Ops·MediumTop 10 most-documented codesMission 7 →Clinical Ops·MediumTop 10 chronic conditionsMission 9 →Clinical Ops·MasterTranslate the codes — top principal diagnosesMission 21 →Payer Claims·EasyTop 5 specialties by claim countMission 3 →Pharma Commercial·MediumTop 10 prescribers by Rx volumeMission 6 →Hospital RCM·MediumTop 10 highest-revenue CPTsMission 6 →Finance·StarterPeek at the chart of accountsMission 1 →Finance·EasyTop 10 vendors — YTD spendMission 7 →Banking·StarterPeek at the customer bookMission 1 →AML & Fraud·StarterMeet the customer bookMission 1 →Retail Banking Operations·StarterPeek at the customer bookMission 1 →Consumer Lending Analyst·StarterPeek at the application bookMission 1 →RevOps·StarterMeet the opportunities tableMission 1 →E-commerce·StarterMeet the orders tableMission 1 →Operations·StarterShow the 5 most recent purchase ordersMission 5 →Operations·EasyTop 5 SKUs by purchase valueMission 8 →Logistics & Transportation Analytics·StarterFirst look at the shipment rosterMission 1 →Logistics & Transportation Analytics·MediumTop 5 most expensive shipmentsMission 13 →Procurement & Sourcing Analytics·StarterTop 10 invoices by amountMission 5 →Procurement & Sourcing Analytics·MediumTop 10 suppliers by spendMission 11 →Warehouse Operations Analytics·StarterInventory snapshot top 10Mission 4 →Warehouse Operations Analytics·EasyTop SKUs by pick frequencyMission 8 →Demand Planning & Forecasting Analytics·StarterRecent actualsMission 4 →Demand Planning & Forecasting Analytics·EasyBest/worst forecast accuracyMission 10 →
COUNT25 missions
Marketing·StarterHow many emails did we send?Mission 3 →Provider·StarterTotal encounter volumeMission 3 →Provider·StarterInsurance mixMission 5 →Banking·StarterOpen accounts right nowMission 3 →AML & Fraud·EasyDaily deposit count per accountMission 7 →Retail Banking Operations·StarterOpen accounts right nowMission 3 →Consumer Lending Analyst·StarterFunded originations this quarterMission 3 →Consumer Lending Analyst·EasyHMDA action_taken distributionMission 8 →Consumer Lending Analyst·Easy30+ delinquent loan countMission 9 →E-commerce·StarterCustomers by countryMission 3 →Operations·StarterHow many suppliers do we work with?Mission 1 →Operations·StarterHow many SKUs do we stock?Mission 3 →Logistics & Transportation Analytics·StarterDelivered shipment countMission 4 →Logistics & Transportation Analytics·StarterStatus breakdownMission 5 →Logistics & Transportation Analytics·EasyCarrier shipment volumeMission 6 →Logistics & Transportation Analytics·MediumCarrier spend with invoice dataMission 15 →Logistics & Transportation Analytics·MediumDuplicate tracking eventsMission 17 →Procurement & Sourcing Analytics·StarterFirst look at suppliersMission 1 →Procurement & Sourcing Analytics·StarterOpen POs countMission 3 →Procurement & Sourcing Analytics·StarterActive contract countMission 4 →Procurement & Sourcing Analytics·EasySupplier PO volumeMission 7 →Warehouse Operations Analytics·StarterZone countMission 1 →Warehouse Operations Analytics·EasySKUs by velocity classMission 6 →Demand Planning & Forecasting Analytics·StarterSKUs by lifecycleMission 1 →Demand Planning & Forecasting Analytics·StarterLocation countMission 2 →
Date arithmetic25 missions
Marketing·MasterRepeat-purchase cohort retentionMission 26 →BI·MediumTenure and salary — any correlation?Mission 15 →Provider·MediumAverage length of stay by departmentMission 11 →Provider·MediumPatient age at admissionMission 15 →Provider·MasterInpatient cohort returns matrixMission 26 →Hospital RCM·MediumAR aging bucketsMission 10 →Hospital RCM·HardDays-in-AR by payer — open claims agingMission 11 →Finance·ExpertLate-posting lag auditMission 21 →Banking·MediumDormant account auditMission 15 →Banking·HardVintage curve — 90+ DPD by MOBMission 16 →AML & Fraud·EasyDormant accounts that just woke upMission 8 →Retail Banking Operations·Hard2025 closed-account exit cohort with tenureMission 18 →Retail Banking Operations·ExpertReg E dispute aging reportMission 24 →Consumer Lending Analyst·HardARM reset wall (next 6 months)Mission 17 →RevOps·MediumPipeline velocity — avg days per stageMission 15 →E-commerce·MediumRefund-aware net revenue by monthMission 15 →E-commerce·MasterRepeat-buyer cohort retentionMission 26 →Operations·MediumAverage lead time per supplierMission 11 →Logistics & Transportation Analytics·MasterShipment delivery delay analysisMission 28 →Procurement & Sourcing Analytics·EasyAverage lead timeMission 9 →Procurement & Sourcing Analytics·MediumPO cycle timeMission 12 →Procurement & Sourcing Analytics·MediumInvoice payment timingMission 14 →Procurement & Sourcing Analytics·MasterSupplier risk scoreMission 29 →Warehouse Operations Analytics·MediumDock-to-stock 3-phaseMission 13 →Warehouse Operations Analytics·HardSLA breachesMission 17 →
SUM25 missions
Marketing·StarterWhat are people buying?Mission 5 →Marketing·MediumWhich campaign drove the most revenue?Mission 11 →Hospital RCM·EasyTotal payments per providerMission 5 →Hospital RCM·MediumTop 10 highest-revenue CPTsMission 6 →Finance·Starter2025 SaaS spend totalMission 4 →Finance·StarterMarch 2025 expense rollupMission 5 →Banking·EasyReversals and chargebacks — clean the spend totalMission 6 →AML & Fraud·StarterDrop the reversalsMission 4 →RevOps·EasyPipeline value by stageMission 6 →E-commerce·EasyRevenue by financial statusMission 6 →Logistics & Transportation Analytics·EasyTotal freight spendMission 7 →Logistics & Transportation Analytics·MediumTop 5 most expensive shipmentsMission 13 →Logistics & Transportation Analytics·MasterRolling 3-month freight cost vs prior periodMission 29 →Logistics & Transportation Analytics·MasterEnd-to-end carrier risk indexMission 30 →Procurement & Sourcing Analytics·EasySpend by categoryMission 6 →Procurement & Sourcing Analytics·HardSpend under management %Mission 19 →Procurement & Sourcing Analytics·ExpertMaverick spend shareMission 23 →Procurement & Sourcing Analytics·MasterCategory x spend-type cubeMission 26 →Procurement & Sourcing Analytics·MasterCategory HHI concentrationMission 27 →Warehouse Operations Analytics·StarterInbound receipt countMission 3 →Warehouse Operations Analytics·MediumWave completion timeMission 15 →Warehouse Operations Analytics·ExpertZone utilizationMission 24 →Demand Planning & Forecasting Analytics·EasyForecast vs actualMission 7 →Demand Planning & Forecasting Analytics·MediumWMAPEMission 11 →Demand Planning & Forecasting Analytics·HardTracking signalMission 17 →
Conditional aggregation24 missions
Provider·MasterPatient satisfaction × readmission gap by departmentMission 29 →Clinical Ops·HardPOA documentation rate by codeMission 12 →Clinical Trials·MediumArm balance — flag the imbalanced trialsMission 6 →Clinical Trials·HardScreen-fail rate vs portfolio averageMission 13 →Payer Claims·MediumDenial rate by CPT (top 10)Mission 6 →Payer Claims·MediumMember denial-rate cohort by regionMission 9 →Pharma Commercial·MediumNRx vs TRx breakdown per productMission 7 →Pharma Commercial·HardHigh-NRx-share prescribers — HAVING thresholdMission 12 →Hospital RCM·MediumClean claim rate per payerMission 7 →Hospital RCM·MediumDenial rate per CPT — high-volume CPTs onlyMission 9 →Hospital RCM·ExpertEdit attribution — denials by front-end fix categoryMission 19 →Banking·MasterCharge-off rate by product — FICO band heatmapMission 26 →Banking·MasterChargeback risk score by merchant categoryMission 28 →AML & Fraud·MasterCash-intensive customer profileMission 27 →AML & Fraud·MasterRule precision scorecard with rankMission 28 →Retail Banking Operations·EasyATM in-network vs foreign economicsMission 10 →Consumer Lending Analyst·MediumHMDA denial-reason rollupMission 12 →Consumer Lending Analyst·ExpertCharge-off rate + principal recovery by vintage yearMission 24 →RevOps·ExpertRep performance dashboardMission 24 →RevOps·HardRegional pipeline scorecardMission 28 →RevOps·HardForecast category pivot — per repMission 32 →E-commerce·MediumRefund rate by productMission 12 →E-commerce·ExpertDTC growth dashboardMission 24 →Operations·EasyOn-time delivery rate per supplierMission 7 →
Self-join24 missions
Marketing·MasterRepeat-purchase cohort retentionMission 26 →BI·MediumWho reports to whom?Mission 12 →Provider·MediumDuplicate patient auditMission 14 →Provider·ExpertReadmission cohort deep diveMission 21 →Provider·MasterInpatient cohort returns matrixMission 26 →Finance·HardDuplicate payment sweepMission 16 →Finance·MasterVendor concentration drift YoYMission 28 →Banking·MediumVelocity feature — auths in 1 hourMission 13 →Banking·HardSame-day amount-swing flagMission 19 →AML & Fraud·MediumCounterparty ring — same two customers, repeatedMission 14 →AML & Fraud·MediumDevice reuse across "separate" customersMission 15 →AML & Fraud·HardEmail reuse — fuzzy entity resolutionMission 16 →AML & Fraud·HardSOUNDEX-style name dedup across customer_idsMission 17 →AML & Fraud·HardMule network — one receives, many sendMission 20 →AML & Fraud·ExpertStructuring ring capstone — everyone in the networkMission 21 →RevOps·MediumDeals that reopened after Closed-WonMission 11 →RevOps·HardMost recent opportunity per accountMission 16 →RevOps·HardClosed-Won cohort retention by monthMission 18 →RevOps·HardAmount discount — committed vs closedMission 20 →E-commerce·MediumRefund rate by productMission 12 →E-commerce·HardMost recent order per customerMission 16 →E-commerce·HardRepeat-purchase cohort retentionMission 18 →E-commerce·HardDiscount-driven AOV impactMission 20 →E-commerce·MasterRepeat-buyer cohort retentionMission 26 →
SQL practice24 missions
Procurement & Sourcing Analytics·HardLead-time CV by supplierMission 17 →Procurement & Sourcing Analytics·ExpertSupplier scorecardMission 21 →Procurement & Sourcing Analytics·ExpertApex consolidated spendMission 25 →Warehouse Operations Analytics·MediumPick accuracyMission 11 →Warehouse Operations Analytics·MediumWorkers vs median LPHMission 14 →Warehouse Operations Analytics·HardAccuracy root causeMission 16 →Warehouse Operations Analytics·HardShift handoff analysisMission 20 →Warehouse Operations Analytics·ExpertUPLH normalized for travelMission 21 →Warehouse Operations Analytics·MasterTenure cohort productivityMission 27 →Demand Planning & Forecasting Analytics·EasyMAPE per SKUMission 6 →Demand Planning & Forecasting Analytics·EasyForecast attainmentMission 9 →Demand Planning & Forecasting Analytics·MediumPromo lift attributionMission 13 →Demand Planning & Forecasting Analytics·MediumForecast coverageMission 14 →Demand Planning & Forecasting Analytics·MediumAccuracy by versionMission 15 →Demand Planning & Forecasting Analytics·HardRolling WMAPEMission 16 →Demand Planning & Forecasting Analytics·HardForecast value-addMission 18 →Demand Planning & Forecasting Analytics·HardLag analysisMission 19 →Demand Planning & Forecasting Analytics·ExpertNaive benchmarkMission 22 →Demand Planning & Forecasting Analytics·ExpertCoefficient of variationMission 23 →Demand Planning & Forecasting Analytics·ExpertPromo uplift attributionMission 24 →Demand Planning & Forecasting Analytics·ExpertSKU segmentationMission 25 →Demand Planning & Forecasting Analytics·MasterFVA by versionMission 26 →Demand Planning & Forecasting Analytics·MasterROI rankingMission 27 →Demand Planning & Forecasting Analytics·MasterS&OP prepMission 29 →
Capstone17 missions
Marketing·MasterMarketing year-end capstone — board KPI summaryMission 30 →BI·MasterBI executive capstone — board KPI panelMission 31 →Provider·ExpertThe CMS Quality DashboardMission 25 →Provider·MasterHospital year-end capstone — board quality dashboardMission 30 →Finance·ExpertBoard-ready P&L capstoneMission 25 →Finance·MasterYear-end FP&A capstone — board KPI panelMission 30 →Banking·MasterCRO board scorecard capstoneMission 30 →AML & Fraud·ExpertThe investigator's dashboardMission 25 →AML & Fraud·MasterInvestigator capstone — case-load boardMission 30 →RevOps·ExpertPipeline hygiene — issue count per opportunityMission 21 →RevOps·ExpertBoard-ready sales operations summaryMission 25 →RevOps·MasterRevOps board capstone — quarter close panelMission 30 →E-commerce·ExpertRFM segmentation — customer scoringMission 21 →E-commerce·ExpertThree-system revenue reconciliationMission 22 →E-commerce·ExpertBoard-ready DTC KPI summaryMission 25 →E-commerce·MasterDTC year-end capstone — board KPI summaryMission 30 →Operations·MasterOperations KPI capstone (board scoreboard)Mission 30 →
HAVING17 missions
Marketing·EasyHow many customers are repeat buyers?Mission 10 →BI·EasyWhich categories are actually selling well?Mission 7 →Provider·HardProvider complication ratesMission 20 →Finance·MediumOverspend flags — actuals vs budgetMission 12 →Banking·MediumDormant account auditMission 15 →AML & Fraud·EasySub-$10K cash deposits by customerMission 6 →AML & Fraud·EasyDormant accounts that just woke upMission 8 →AML & Fraud·MediumStructuring candidates — $9K–$9,999 over 14 daysMission 13 →AML & Fraud·HardMule network — one receives, many sendMission 20 →Retail Banking Operations·MediumDormant account audit (180+ days silent)Mission 14 →Operations·MediumLead-time consistency per supplierMission 14 →Operations·ExpertLead-time trend per supplier (monthly average)Mission 22 →Logistics & Transportation Analytics·MediumDetention hot spots — lanes with high dwellMission 12 →Logistics & Transportation Analytics·MediumDuplicate tracking eventsMission 17 →Logistics & Transportation Analytics·HardPerfect score carriers — OTD and in-full combinedMission 21 →Procurement & Sourcing Analytics·HardSingle-source category riskMission 20 →Procurement & Sourcing Analytics·MasterDual-source coverageMission 28 →
COUNT(*)16 missions
Clinical Ops·EasyEncounter diagnosis volume by typeMission 4 →Clinical Ops·EasyThe POA tallyMission 5 →Clinical Trials·EasyActive trials by phaseMission 1 →Clinical Trials·EasyVisit completion vs no-showMission 4 →Clinical Trials·MediumPhase-3 trial rosterMission 8 →Payer Claims·EasyActive members by plan_typeMission 1 →Payer Claims·EasyDenied claims this quarterMission 5 →Payer Claims·MediumCARC code frequency × categoryMission 8 →Payer Claims·MediumFirst-pass appeal volume by levelMission 10 →Pharma Commercial·EasyRx fills per productMission 3 →Pharma Commercial·EasyCalls per repMission 4 →Pharma Commercial·EasyPayer mix — Rx count per plan_typeMission 5 →Pharma Commercial·MediumQuarterly call volume trendMission 8 →Hospital RCM·EasyActive payers by plan typeMission 1 →Hospital RCM·EasyCharges per CPT codeMission 3 →Hospital RCM·MediumMonthly claim volume trendMission 8 →
Multi-CTE pipeline16 missions
Marketing·MasterMarketing year-end capstone — board KPI summaryMission 30 →Provider·ExpertThe CMS Quality DashboardMission 25 →Provider·MasterHospital year-end capstone — board quality dashboardMission 30 →Clinical Ops·ExpertDepartment CCSR concentration (HHI)Mission 18 →Clinical Ops·MasterHCC chronic burden — patient risk tiering capstoneMission 25 →Clinical Trials·HardScreen-fail rate vs portfolio averageMission 13 →Pharma Commercial·MasterHCP segmentation capstone — multi-metric ranks + decile recompute + segment labelMission 25 →Hospital RCM·MasterPatient revenue segmentation capstone — multi-metric ranks + segment labelMission 25 →Finance·ExpertBoard-ready P&L capstoneMission 25 →Banking·ExpertCECL lifetime loss projection by vintageMission 23 →Banking·ExpertPortfolio risk scorecard capstoneMission 25 →AML & Fraud·ExpertStructuring ring capstone — everyone in the networkMission 21 →AML & Fraud·ExpertThe investigator's dashboardMission 25 →RevOps·ExpertBoard-ready sales operations summaryMission 25 →E-commerce·ExpertBoard-ready DTC KPI summaryMission 25 →E-commerce·MasterDTC year-end capstone — board KPI summaryMission 30 →
AVG15 missions
Marketing·MediumWhat's our average order value per campaign?Mission 15 →Provider·EasyED wait time overviewMission 8 →Payer Claims·MediumAvg paid_amt by plan_type × fundingMission 7 →Finance·MediumRevenue seasonality by monthMission 13 →Consumer Lending Analyst·EasyAvg funded amount by loan purposeMission 7 →RevOps·EasyAverage deal size by regionMission 9 →RevOps·MediumPipeline velocity — avg days per stageMission 15 →E-commerce·EasyAverage order value by channelMission 9 →Logistics & Transportation Analytics·ExpertWeight-normalized freight cost per mileMission 22 →Procurement & Sourcing Analytics·EasyAverage lead timeMission 9 →Procurement & Sourcing Analytics·MediumPO cycle timeMission 12 →Procurement & Sourcing Analytics·MediumInvoice payment timingMission 14 →Warehouse Operations Analytics·StarterDock-to-stock averageMission 5 →Warehouse Operations Analytics·EasyCycle count variance by zoneMission 10 →Demand Planning & Forecasting Analytics·EasyBias by categoryMission 8 →
LEFT JOIN15 missions
Marketing·EasyHow many customers never bought anything?Mission 8 →Marketing·MediumWhich campaign has the best ROI?Mission 12 →BI·StarterWhich region should we expand next?Mission 4 →Provider·EasyDepartments with no encountersMission 9 →Provider·HardDepartment utilization ratesMission 19 →Clinical Ops·MediumOrphan codes — codebook gapsMission 10 →Pharma Commercial·MediumRep call activity vs target — surface zero-call repsMission 10 →Banking·EasyApproval rate by FICO bandMission 9 →AML & Fraud·EasyCustomers with no KYC refresh in 3 yearsMission 9 →Retail Banking Operations·MediumDormant account audit (180+ days silent)Mission 14 →RevOps·EasyLeads with no account matchMission 10 →E-commerce·EasyProducts with zero ordersMission 10 →Operations·HardSupplier scorecard (lead time + on-time + cancellation)Mission 17 →Operations·HardStockout root cause: SKUs with no incoming POMission 19 →Operations·MasterSupplier health capstone (multi-CTE scorecard)Mission 26 →
CTE12 missions
Provider·ExpertReadmission cohort deep diveMission 21 →Provider·ExpertPatient satisfaction trend with moving averageMission 22 →Provider·ExpertTop diagnoses year-over-yearMission 23 →Pharma Commercial·HardDecile-based prescriber tiers — recompute from Rx volumeMission 11 →Hospital RCM·HardFirst-pass yield quartiles — NTILE on payer-level FPYMission 12 →Finance·ExpertLate-posting lag auditMission 21 →Finance·ExpertVendor spend — new vs. recurringMission 22 →Banking·HardVintage curve — 90+ DPD by MOBMission 16 →Banking·ExpertPSI — score distribution vs baselineMission 21 →Banking·ExpertKS statistic on PD model scoresMission 22 →AML & Fraud·ExpertCTR / SAR filing candidate listMission 22 →RevOps·HardPoint-in-time forecast snapshot (SCD2)Mission 17 →
Data quality12 missions
Marketing·StarterWelcome — preview the customer tableMission 1 →Provider·StarterMeet the patientsMission 1 →Provider·StarterInsurance mixMission 5 →Finance·StarterPeek at the chart of accountsMission 1 →Finance·StarterAccount-type inventoryMission 3 →Banking·StarterPeek at the customer bookMission 1 →Banking·EasyReversals and chargebacks — clean the spend totalMission 6 →AML & Fraud·StarterMeet the customer bookMission 1 →AML & Fraud·StarterDrop the reversalsMission 4 →Retail Banking Operations·StarterPeek at the customer bookMission 1 →Retail Banking Operations·StarterProduct taxonomy inventoryMission 2 →Consumer Lending Analyst·StarterPeek at the application bookMission 1 →
INNER JOIN12 missions
Clinical Ops·MediumTranslate every diagnosis on the chartMission 6 →Clinical Trials·EasyEnrollments per siteMission 2 →Payer Claims·EasyActive members by plan_typeMission 1 →Payer Claims·EasyTop 5 specialties by claim countMission 3 →Payer Claims·EasyDenied claims this quarterMission 5 →Payer Claims·MediumAvg paid_amt by plan_type × fundingMission 7 →Pharma Commercial·EasyPayer mix — Rx count per plan_typeMission 5 →Pharma Commercial·MediumTop 10 prescribers by Rx volumeMission 6 →Hospital RCM·EasyCharges per CPT codeMission 3 →Hospital RCM·EasyClaims submitted per payerMission 4 →Hospital RCM·MediumTop 10 highest-revenue CPTsMission 6 →Hospital RCM·MediumDenial rate per CPT — high-volume CPTs onlyMission 9 →
SELECT12 missions
Marketing·StarterWelcome — preview the customer tableMission 1 →Marketing·StarterWhat campaigns are running?Mission 2 →Provider·StarterMeet the patientsMission 1 →Provider·StarterHow many departments do we have?Mission 2 →Finance·StarterPeek at the chart of accountsMission 1 →Finance·StarterCost-center ownership mapMission 2 →Banking·StarterPeek at the customer bookMission 1 →AML & Fraud·StarterMeet the customer bookMission 1 →Retail Banking Operations·StarterPeek at the customer bookMission 1 →Consumer Lending Analyst·StarterPeek at the application bookMission 1 →RevOps·StarterMeet the opportunities tableMission 1 →E-commerce·StarterMeet the orders tableMission 1 →
Ratio11 missions
Finance·EasyQuarterly gross-margin rollupMission 10 →Banking·MediumMonthly net charge-off rate by productMission 11 →AML & Fraud·HardAlert precision — how good is our rule?Mission 18 →AML & Fraud·HardFalse positives by rule — tuning targetsMission 19 →Consumer Lending Analyst·EasyApproval rate by productMission 6 →Consumer Lending Analyst·MediumApproval rate by FICO bandMission 11 →RevOps·EasyWin rate by sales repMission 8 →RevOps·HardAmount discount — committed vs closedMission 20 →E-commerce·EasyRepeat-customer rateMission 8 →E-commerce·MediumRefund rate by productMission 12 →E-commerce·HardDiscount-driven AOV impactMission 20 →
CASE10 missions
Marketing·MediumWhich campaign has the best ROI?Mission 12 →Marketing·HardNormalize the gender messMission 18 →BI·StarterBoard deck needs revenue by quarterMission 1 →Provider·MediumReadmission rate by insurance typeMission 13 →Finance·EasyQuarterly gross-margin rollupMission 10 →Finance·MediumMarch budget-variance checkMission 11 →Consumer Lending Analyst·HardApproval gap by LMI tractMission 20 →RevOps·HardQuarterly bookings waterfall — new vs expandMission 19 →RevOps·ExpertSales cycle segmentation by deal-size bucketMission 23 →E-commerce·MediumRefund-aware net revenue by monthMission 15 →
CASE aggregation10 missions
Marketing·ExpertTotal refund impactMission 24 →Marketing·MasterLTV decomposition by acquisition channelMission 28 →Finance·MediumRefund leakage — net revenue impactMission 14 →Banking·EasyApproval rate by FICO bandMission 9 →Banking·MediumMonthly net charge-off rate by productMission 11 →AML & Fraud·EasyWire vs cash — volume by channel groupMission 10 →AML & Fraud·HardAlert precision — how good is our rule?Mission 18 →Consumer Lending Analyst·EasyApproval rate by productMission 6 →RevOps·EasyWin rate by sales repMission 8 →E-commerce·EasyRepeat-customer rateMission 8 →
COUNT DISTINCT10 missions
Marketing·EasyCount unique customersMission 6 →Marketing·ExpertCustomers buying across categoriesMission 23 →BI·EasyWhich categories are actually selling well?Mission 7 →BI·EasyHow many unique customers per region?Mission 9 →Clinical Ops·MasterHCC chronic burden — patient risk tiering capstoneMission 25 →Banking·StarterCustomer vs account — know the grainMission 5 →AML & Fraud·MediumDevice reuse across "separate" customersMission 15 →AML & Fraud·HardMule network — one receives, many sendMission 20 →Retail Banking Operations·StarterActive deposit customers by stateMission 4 →RevOps·MediumMid-cycle owner reassignmentsMission 13 →
Bucketing9 missions
BI·EasyDiscount tiers need a reality checkMission 6 →BI·MediumTenure and salary — any correlation?Mission 15 →Provider·MediumED throughput — the real numbersMission 12 →Finance·HardBudget-attainment heat mapMission 20 →Finance·ExpertLate-posting lag auditMission 21 →Banking·EasyDelinquency bucket snapshotMission 7 →Banking·ExpertPSI — score distribution vs baselineMission 21 →Consumer Lending Analyst·ExpertPortfolio LTV stratification with seasoningMission 22 →RevOps·ExpertSales cycle segmentation by deal-size bucketMission 23 →
CASE WHEN9 missions
BI·EasyDiscount tiers need a reality checkMission 6 →BI·EasyTag every sale by sizeMission 10 →Provider·MediumED throughput — the real numbersMission 12 →Banking·EasyDelinquency bucket snapshotMission 7 →Banking·EasyFICO band distribution at originationMission 8 →Logistics & Transportation Analytics·MediumOn-time delivery rate by carrierMission 8 →Logistics & Transportation Analytics·MediumIn-full rate by carrierMission 9 →Logistics & Transportation Analytics·HardLane-level OTD with carrier namesMission 20 →Logistics & Transportation Analytics·ExpertCarrier scorecard — four metrics in one queryMission 24 →
Float promotion9 missions
Clinical Ops·ExpertDepartment CCSR concentration (HHI)Mission 18 →Clinical Trials·MediumArm balance — flag the imbalanced trialsMission 6 →Clinical Trials·ExpertSite HHI — concentration of enrollments per therapeutic areaMission 18 →Payer Claims·MediumDenial rate by CPT (top 10)Mission 6 →Payer Claims·HardTop denial concentration via HHI on CARC codesMission 12 →Pharma Commercial·MediumNRx vs TRx breakdown per productMission 7 →Pharma Commercial·ExpertTerritory market share HHI — concentration of Rx volumeMission 18 →Hospital RCM·MediumClean claim rate per payerMission 7 →Hospital RCM·ExpertPayer concentration HHI per service lineMission 18 →
DISTINCT8 missions
Finance·StarterAccount-type inventoryMission 3 →Banking·StarterWhat products do we book?Mission 2 →AML & Fraud·StarterWhat channels do we see?Mission 2 →Retail Banking Operations·StarterProduct taxonomy inventoryMission 2 →RevOps·StarterWhat stages exist in the pipeline?Mission 2 →E-commerce·StarterWhat financial statuses exist?Mission 2 →Operations·StarterList our SKU categoriesMission 4 →Operations·MediumLatest inventory on hand per warehouseMission 12 →
GROUP BY HAVING8 missions
Marketing·ExpertSomething's off with our numbersMission 21 →Provider·MediumDuplicate patient auditMission 14 →Payer Claims·MediumDenial rate by CPT (top 10)Mission 6 →Finance·EasyVendor duplicates auditMission 6 →Finance·HardDuplicate payment sweepMission 16 →Banking·MediumStructuring flag — sub-$10K cash depositsMission 14 →AML & Fraud·MediumCounterparty ring — same two customers, repeatedMission 14 →RevOps·MediumMid-cycle owner reassignmentsMission 13 →
IS NULL8 missions
Marketing·EasyHow many customers never bought anything?Mission 8 →Marketing·HardHow many organic purchases are we getting?Mission 19 →Provider·EasyDepartments with no encountersMission 9 →Banking·StarterOpen accounts right nowMission 3 →AML & Fraud·EasyCustomers with no KYC refresh in 3 yearsMission 9 →Retail Banking Operations·StarterOpen accounts right nowMission 3 →RevOps·EasyLeads with no account matchMission 10 →E-commerce·EasyProducts with zero ordersMission 10 →
ORDER BY DESC8 missions
Clinical Ops·MediumTop 10 most-documented codesMission 7 →Clinical Trials·EasyEnrollments per siteMission 2 →Payer Claims·EasyTop 5 specialties by claim countMission 3 →Pharma Commercial·EasyRx fills per productMission 3 →Pharma Commercial·MediumTop 10 prescribers by Rx volumeMission 6 →Hospital RCM·EasyClaims submitted per payerMission 4 →Hospital RCM·MediumTop 10 highest-revenue CPTsMission 6 →Operations·StarterShow the 5 most recent purchase ordersMission 5 →
ROW_NUMBER8 missions
Banking·HardQuarter-end balance snapshot (Y-9C style)Mission 20 →Consumer Lending Analyst·HardEarly-Payment Default rate by vintage monthMission 16 →RevOps·MediumTop 3 reps per region by closed-won revenueMission 14 →RevOps·HardMost recent opportunity per accountMission 16 →E-commerce·MediumTop 3 products per category by revenueMission 14 →E-commerce·HardMost recent order per customerMission 16 →Operations·HardTop 3 SKUs per category by purchase valueMission 16 →Operations·ExpertPoint-in-time supplier on-time target (SCD2 reconstruction)Mission 21 →
CASE bucketing7 missions
Clinical Ops·MasterHCC chronic burden — patient risk tiering capstoneMission 25 →Hospital RCM·MediumAR aging bucketsMission 10 →Hospital RCM·ExpertEdit attribution — denials by front-end fix categoryMission 19 →Retail Banking Operations·EasyNSF / OD fee revenue by FICO bandMission 9 →Retail Banking Operations·MediumRate-tier balance distributionMission 12 →Consumer Lending Analyst·MediumApproval rate by FICO bandMission 11 →Operations·ExpertABC analysis: classify SKUs by spend shareMission 23 →
Exploration7 missions
Marketing·StarterWhat campaigns are running?Mission 2 →Provider·StarterHow many departments do we have?Mission 2 →Finance·StarterCost-center ownership mapMission 2 →Banking·StarterWhat products do we book?Mission 2 →AML & Fraud·StarterWhat channels do we see?Mission 2 →RevOps·StarterWhat stages exist in the pipeline?Mission 2 →E-commerce·StarterWhat financial statuses exist?Mission 2 →
Multi-table JOIN7 missions
Marketing·MediumTop 5 customers by spendMission 13 →BI·EasyTag every sale by sizeMission 10 →BI·HardThree-table join: who sold what where?Mission 18 →Retail Banking Operations·EasyCD maturity wall (next 90 days)Mission 7 →Consumer Lending Analyst·MediumPricing exception detector (rate vs benchmark)Mission 14 →Consumer Lending Analyst·HardApproval gap by LMI tractMission 20 →Consumer Lending Analyst·ExpertHMDA LAR row reconstructionMission 23 →
NULL handling7 missions
BI·StarterWhich region should we expand next?Mission 4 →BI·EasyDiscount tiers need a reality checkMission 6 →Provider·MediumAverage length of stay by departmentMission 11 →Clinical Trials·EasyWithdrawal reasons breakdownMission 3 →Consumer Lending Analyst·MediumHMDA denial-reason rollupMission 12 →Procurement & Sourcing Analytics·MediumInvoice payment timingMission 14 →Procurement & Sourcing Analytics·HardContract compliance rateMission 18 →
PARTITION BY7 missions
BI·HardTop 2 products per categoryMission 16 →BI·ExpertYear-over-year revenue by quarterMission 21 →Clinical Ops·HardTop 3 codes per body systemMission 11 →Clinical Trials·HardFirst adverse event per enrollmentMission 11 →Finance·HardYoY revenue growth by monthMission 18 →Banking·HardRoll-rate transition matrixMission 17 →Operations·HardTop 3 SKUs per category by purchase valueMission 16 →
WHERE filter7 missions
Clinical Trials·EasyActive trials by phaseMission 1 →Clinical Trials·EasyWithdrawal reasons breakdownMission 3 →Payer Claims·EasyOut-of-network provider listMission 4 →Pharma Commercial·EasyActive products by therapeutic classMission 1 →Pharma Commercial·EasyHCPs in cardiology specialtyMission 2 →Hospital RCM·EasyMedicare patients by demographicMission 2 →Operations·EasyStock-out risk: SKUs with under 7 days of supplyMission 9 →
Date filter6 missions
Finance·Starter2025 SaaS spend totalMission 4 →Retail Banking Operations·StarterNet new checking accounts this weekMission 5 →Consumer Lending Analyst·StarterFunded originations this quarterMission 3 →Consumer Lending Analyst·StarterNet new mortgages last 30 daysMission 5 →RevOps·HardPoint-in-time forecast snapshot (SCD2)Mission 17 →Operations·EasyTotal units ordered per category last quarterMission 6 →
JOINs6 missions
Marketing·EasyWhich channel gets the best open rate?Mission 9 →Marketing·MediumWhich campaign drove the most revenue?Mission 11 →Marketing·MediumRevenue by stateMission 14 →BI·StarterWho is hitting their sales targets?Mission 2 →BI·EasyHow many unique customers per region?Mission 9 →Finance·MediumMarch budget-variance checkMission 11 →
LAG window6 missions
Clinical Trials·HardVisit drift trend per enrollmentMission 15 →Payer Claims·ExpertSliding-window repeat-denial detection (LAG within member-CPT)Mission 19 →Pharma Commercial·HardCall-to-Rx attribution lag — LAG window across event streamsMission 15 →Hospital RCM·HardClaim-to-remit lag — LAG window across event streamsMission 15 →Banking·MasterVintage delinquency drift YoY (12-MOB)Mission 27 →RevOps·MasterStage conversion funnel with drop-offMission 27 →
NULLIF guard6 missions
Clinical Trials·ExpertDrug vs placebo AE rate delta — paired per-arm comparisonMission 19 →Payer Claims·HardProvider denial-rate outliers (specialty-adjusted)Mission 11 →Payer Claims·ExpertOverturn% by level × denial_category (MAX(CASE) pivot)Mission 16 →Consumer Lending Analyst·ExpertCharge-off rate + principal recovery by vintage yearMission 24 →Consumer Lending Analyst·MasterFair Lending disparity index by FICO band (Black vs White)Mission 26 →RevOps·HardRegional pipeline scorecardMission 28 →
Single-table SELECT6 missions
Clinical Ops·EasyBrowse the cardiology codebookMission 1 →Clinical Trials·EasyActive trials by phaseMission 1 →Payer Claims·EasyOut-of-network provider listMission 4 →Pharma Commercial·EasyActive products by therapeutic classMission 1 →Pharma Commercial·EasyHCPs in cardiology specialtyMission 2 →Hospital RCM·EasyActive payers by plan typeMission 1 →
Subqueries6 missions
Marketing·EasyHow many customers are repeat buyers?Mission 10 →Marketing·HardHow many customers opened zero emails?Mission 20 →Marketing·ExpertCustomers buying across categoriesMission 23 →BI·StarterProduct mix is shiftingMission 3 →BI·EasyFind reps outselling their department averageMission 8 →Finance·MediumOverspend flags — actuals vs budgetMission 12 →
Top-N6 missions
BI·HardTop 2 products per categoryMission 16 →AML & Fraud·ExpertSanctions-list fuzzy match scorecardMission 23 →Consumer Lending Analyst·EasyOriginations by LO (top 10)Mission 10 →RevOps·StarterDeals over $50K by accountMission 5 →E-commerce·StarterOrders over $200 by customerMission 5 →Operations·HardInventory turnover ratio (last week)Mission 20 →
Window frame6 missions
BI·HardRunning revenue total by monthMission 20 →BI·ExpertThree-month moving averageMission 22 →Finance·MediumRunning cash burnMission 15 →Banking·HardRolling velocity — ≥5 auths in 10 minutesMission 18 →AML & Fraud·MediumVelocity — 5+ cash deposits in 24 hoursMission 12 →AML & Fraud·MediumStructuring candidates — $9K–$9,999 over 14 daysMission 13 →
Attribution5 missions
Marketing·HardIs our email actually working?Mission 16 →Marketing·HardHow many organic purchases are we getting?Mission 19 →Marketing·MasterMulti-touch attribution — last-click vs first-click vs linearMission 27 →E-commerce·MediumSource/medium attribution — last-touchMission 13 →E-commerce·MasterMulti-touch attribution — last-click vs first-click vs linearMission 27 →
DATE_TRUNC5 missions
Banking·MediumVintage originations pacingMission 12 →AML & Fraud·EasyDaily deposit count per accountMission 7 →Consumer Lending Analyst·MediumLate-payment rate by vintage monthMission 15 →RevOps·EasyDeals by close quarterMission 7 →E-commerce·EasyOrders by monthMission 7 →
LAG()5 missions
BI·MediumMonthly revenue trend with growth rateMission 13 →BI·ExpertYear-over-year revenue by quarterMission 21 →Provider·HardMonth-over-month encounter trendMission 18 →Finance·HardYoY revenue growth by monthMission 18 →Banking·HardRoll-rate transition matrixMission 17 →
Multi-CTE rollup5 missions
Clinical Trials·MasterTrial portfolio scorecard — every trial, every metricMission 21 →Pharma Commercial·MasterBrand performance scorecard — every product, every metricMission 21 →Hospital RCM·MasterRCM scorecard — every payer, every KPIMission 21 →Retail Banking Operations·MasterTreasury daily liquidity dashboardMission 29 →Consumer Lending Analyst·MasterCECL-style loss reserve decompositionMission 29 →
Multi-CTE UNION ALL5 missions
BI·MasterBI executive capstone — board KPI panelMission 31 →Finance·MasterYear-end FP&A capstone — board KPI panelMission 30 →Banking·MasterCRO board scorecard capstoneMission 30 →AML & Fraud·MasterInvestigator capstone — case-load boardMission 30 →RevOps·MasterRevOps board capstone — quarter close panelMission 30 →
NTILE(4) window5 missions
Clinical Ops·ExpertDiagnosis chronicity ladderMission 20 →Clinical Trials·ExpertAdherence quartiles × outcome — NTILE × status pivotMission 20 →Payer Claims·HardAppeals TAT percentiles by level (NTILE)Mission 15 →Pharma Commercial·HardCopay distribution per product — NTILE(4) quartilesMission 13 →Hospital RCM·HardFirst-pass yield quartiles — NTILE on payer-level FPYMission 12 →
Percentages5 missions
Marketing·EasyWhich channel gets the best open rate?Mission 9 →Marketing·ExpertTotal refund impactMission 24 →BI·StarterProduct mix is shiftingMission 3 →Provider·MediumReadmission rate by insurance typeMission 13 →Banking·EasyApproval rate by FICO bandMission 9 →
TRIM5 missions
Marketing·HardClean up the traffic sourcesMission 17 →Marketing·ExpertFix the product category messMission 22 →Provider·EasyTop 10 diagnosesMission 7 →Provider·ExpertTop diagnoses year-over-yearMission 23 →Finance·EasyVendor duplicates auditMission 6 →
UNION ALL5 missions
Pharma Commercial·MasterData quality audit — orphan NPIs + NULL plan_ids in one reportMission 24 →Hospital RCM·MasterData quality audit — orphan claims + NULL denials in one reportMission 24 →Retail Banking Operations·MasterTreasury daily liquidity dashboardMission 29 →Consumer Lending Analyst·MasterCECL-style loss reserve decompositionMission 29 →Operations·MasterOperations KPI capstone (board scoreboard)Mission 30 →
10-KPI panel4 missions
BI·MasterBI executive capstone — board KPI panelMission 31 →Banking·MasterCRO board scorecard capstoneMission 30 →AML & Fraud·MasterInvestigator capstone — case-load boardMission 30 →RevOps·MasterRevOps board capstone — quarter close panelMission 30 →
Aggregation4 missions
Marketing·StarterHow many emails did we send?Mission 3 →BI·StarterBoard deck needs revenue by quarterMission 1 →Provider·StarterTotal encounter volumeMission 3 →Finance·EasyQuarterly gross-margin rollupMission 10 →
Date math4 missions
Marketing·HardIs our email actually working?Mission 16 →AML & Fraud·EasyCustomers with no KYC refresh in 3 yearsMission 9 →Retail Banking Operations·MediumDormant account audit (180+ days silent)Mission 14 →Consumer Lending Analyst·ExpertPortfolio LTV stratification with seasoningMission 22 →
Date window4 missions
Provider·ExpertReadmission cohort deep diveMission 21 →Finance·HardDuplicate payment sweepMission 16 →Banking·MediumVelocity feature — auths in 1 hourMission 13 →Banking·HardSame-day amount-swing flagMission 19 →
LAG4 missions
Provider·ExpertPatient satisfaction trend with moving averageMission 22 →RevOps·MediumStage regressions — deals that moved backwardMission 12 →RevOps·MediumPipeline velocity — avg days per stageMission 15 →Operations·HardDemand week-over-week changeMission 18 →
MAX4 missions
Provider·EasyED wait time overviewMission 8 →Banking·MediumDormant account auditMission 15 →Banking·ExpertKS statistic on PD model scoresMission 22 →AML & Fraud·EasyDormant accounts that just woke upMission 8 →
NULLIF4 missions
Marketing·MasterSend fatigue — engagement decay by send rankMission 29 →AML & Fraud·MasterRule precision scorecard with rankMission 28 →RevOps·MediumQuota attainment by rep (2025-Q1)Mission 31 →E-commerce·MasterGA4 vs Shopify drift forensicsMission 28 →
RANK window4 missions
Clinical Trials·HardSite rank by enrollment velocityMission 14 →Payer Claims·ExpertProvider appeal-success ranking within specialty (RANK PARTITION)Mission 18 →Pharma Commercial·HardTop product per territory — RANK PARTITIONMission 14 →Hospital RCM·HardTop denial reason per department — RANK PARTITIONMission 13 →
ROUND4 missions
Logistics & Transportation Analytics·MediumIn-full rate by carrierMission 9 →Logistics & Transportation Analytics·MediumOverbilled invoicesMission 14 →Logistics & Transportation Analytics·ExpertWeight-normalized freight cost per mileMission 22 →Logistics & Transportation Analytics·MasterRolling 3-month freight cost vs prior periodMission 29 →
Window function4 missions
RevOps·MediumStage regressions — deals that moved backwardMission 12 →RevOps·MediumTop 3 reps per region by closed-won revenueMission 14 →E-commerce·MediumSource/medium attribution — last-touchMission 13 →Operations·HardDemand week-over-week changeMission 18 →
Window functions4 missions
BI·MediumRank the sales teamMission 11 →BI·ExpertHire cohort performance analysisMission 23 →Provider·HardRank specialties by encounter volumeMission 16 →Finance·HardCost center rank by 2025 OpExMission 19 →
Anti-join3 missions
Clinical Ops·MasterData quality audit — POA gaps and legacy codesMission 24 →Payer Claims·ExpertOON leakage cohort (anti-join)Mission 17 →Operations·HardStockout root cause: SKUs with no incoming POMission 19 →
Cohort3 missions
Banking·ExpertChampion–challenger collections backtestMission 24 →RevOps·HardClosed-Won cohort retention by monthMission 18 →E-commerce·HardRepeat-purchase cohort retentionMission 18 →
Cohort filter3 missions
Clinical Ops·HardEncounters carrying multiple HCCsMission 13 →Pharma Commercial·ExpertPersistence quartiles — NTILE on per-HCP Cardiozin fill countsMission 20 →Hospital RCM·ExpertAR cohort persistence quartiles — claim-to-payment lag distributionMission 20 →
Cohort intersection3 missions
Payer Claims·ExpertOON leakage cohort (anti-join)Mission 17 →Pharma Commercial·ExpertSwitcher cohort — competitor-pre-launch to Cardiozin-post-launchMission 17 →Hospital RCM·ExpertAppeal overturn cohort — denied claims that paid after appealMission 17 →
Cohort matrix3 missions
Marketing·MasterRepeat-purchase cohort retentionMission 26 →Provider·MasterInpatient cohort returns matrixMission 26 →E-commerce·MasterRepeat-buyer cohort retentionMission 26 →
Correlated subquery3 missions
BI·HardFind products with no sales last quarterMission 17 →Provider·HardProvider complication ratesMission 20 →Pharma Commercial·ExpertMulti-touch attribution — sample-call vs plain-call → RxMission 19 →
Date diff3 missions
Payer Claims·HardAppeals TAT percentiles by level (NTILE)Mission 15 →Pharma Commercial·HardCall-to-Rx attribution lag — LAG window across event streamsMission 15 →Hospital RCM·HardClaim-to-remit lag — LAG window across event streamsMission 15 →
Date truncation3 missions
BI·MediumMonthly revenue trend with growth rateMission 13 →Payer Claims·EasyClaims volume by service monthMission 2 →Finance·EasyDepartmental spend by monthMission 9 →
Filters3 missions
AML & Fraud·StarterCash deposits over $10KMission 5 →RevOps·StarterDrop the Closed-Lost dealsMission 4 →E-commerce·StarterDrop the voided / refunded ordersMission 4 →
Latest snapshot3 missions
Operations·EasyStock-out risk: SKUs with under 7 days of supplyMission 9 →Operations·MediumOverstocked SKUs (over 15 days of supply)Mission 15 →Operations·ExpertReorder-point breach: SKUs below their ROPMission 25 →
LOWER3 missions
Marketing·HardClean up the traffic sourcesMission 17 →Finance·EasyVendor duplicates auditMission 6 →AML & Fraud·HardEmail reuse — fuzzy entity resolutionMission 16 →
Multi-JOIN3 missions
Marketing·ExpertThe full campaign scorecardMission 25 →Provider·MediumED throughput — the real numbersMission 12 →Finance·EasyDepartmental spend by monthMission 9 →
NTILE3 missions
RevOps·ExpertSales cycle segmentation by deal-size bucketMission 23 →E-commerce·ExpertRFM segmentation — customer scoringMission 21 →Operations·ExpertABC analysis: classify SKUs by spend shareMission 23 →
Pivot3 missions
Finance·ExpertBoard-ready P&L capstoneMission 25 →Banking·HardRoll-rate transition matrixMission 17 →RevOps·HardForecast category pivot — per repMission 32 →
RANK()3 missions
BI·MediumRank the sales teamMission 11 →Provider·HardRank specialties by encounter volumeMission 16 →Finance·HardCost center rank by 2025 OpExMission 19 →
Tie handling3 missions
Payer Claims·ExpertProvider appeal-success ranking within specialty (RANK PARTITION)Mission 18 →Pharma Commercial·HardTop product per territory — RANK PARTITIONMission 14 →Hospital RCM·HardTop denial reason per department — RANK PARTITIONMission 13 →
Top-N per group3 missions
RevOps·MediumTop 3 reps per region by closed-won revenueMission 14 →E-commerce·MediumTop 3 products per category by revenueMission 14 →Operations·HardTop 3 SKUs per category by purchase valueMission 16 →
Two-pass aggregation3 missions
Clinical Ops·MasterThe comorbidity profile — what travels with heart failureMission 22 →Pharma Commercial·MasterRx adherence proxy — fills per HCP×product across therapeutic classMission 23 →Hospital RCM·MasterPayment-timing proxy across payer mixMission 23 →
UNION ALL labeled rows3 missions
Marketing·MasterMarketing year-end capstone — board KPI summaryMission 30 →Provider·MasterHospital year-end capstone — board quality dashboardMission 30 →E-commerce·MasterDTC year-end capstone — board KPI summaryMission 30 →
WHERE flag = 13 missions
Clinical Ops·EasyPull the chronic disease listMission 2 →Clinical Ops·EasyThe HCC-eligible code listMission 3 →Clinical Ops·MediumTop 10 chronic conditionsMission 9 →
% calc + float promotion2 missions
Clinical Ops·MediumBody system distributionMission 8 →Clinical Ops·MasterCCSR service-line rollupMission 23 →
3-table INNER JOIN2 missions
Clinical Trials·MediumPhase-3 trial rosterMission 8 →Pharma Commercial·MediumTerritory roster — HCPs per territoryMission 9 →
3-table JOIN2 missions
Clinical Ops·MasterTranslate the codes — top principal diagnosesMission 21 →Clinical Trials·MediumAverage visit drift by siteMission 9 →
Aggregate-then-bucket2 missions
Pharma Commercial·HardDecile-based prescriber tiers — recompute from Rx volumeMission 11 →Hospital RCM·HardFirst-pass yield quartiles — NTILE on payer-level FPYMission 12 →
Backtest2 missions
RevOps·HardAmount discount — committed vs closedMission 20 →E-commerce·HardDiscount-driven AOV impactMission 20 →
BETWEEN2 missions
Retail Banking Operations·EasyCD maturity wall (next 90 days)Mission 7 →Consumer Lending Analyst·HardARM reset wall (next 6 months)Mission 17 →
CASE buckets2 missions
Provider·MediumPatient age at admissionMission 15 →Consumer Lending Analyst·MediumDTI bucket pivot for originationsMission 13 →
CASE pivot2 missions
BI·MediumPivot revenue by category and yearMission 14 →Finance·HardBudget-attainment heat mapMission 20 →
COALESCE2 missions
BI·StarterWhich region should we expand next?Mission 4 →Provider·HardDepartment utilization ratesMission 19 →
Cohort CTE2 missions
Clinical Ops·MasterThe comorbidity profile — what travels with heart failureMission 22 →Retail Banking Operations·HardOnboarding funnel: 90-day primary-relationship rateMission 15 →
Concentration risk2 missions
Payer Claims·ExpertPlan-type adverse selection: high-utilizer concentration (NTILE × cumulative %)Mission 20 →Finance·MasterVendor concentration drift YoYMission 28 →
Conditional COUNT pivot2 missions
Retail Banking Operations·ExpertCustomer 360 — top depositorsMission 25 →Consumer Lending Analyst·ExpertDelinquency aging bucket pivot by productMission 21 →
Conditional MAX2 missions
Retail Banking Operations·MasterDeposit beta by product subcategoryMission 27 →Consumer Lending Analyst·MasterALCO portfolio stratification dashboardMission 27 →
COUNT() OVER2 missions
Banking·HardRolling velocity — ≥5 auths in 10 minutesMission 18 →AML & Fraud·MediumVelocity — 5+ cash deposits in 24 hoursMission 12 →
Cross-tab2 missions
BI·MediumPivot revenue by category and yearMission 14 →Payer Claims·MasterNetwork adequacy gap: specialty × regionMission 25 →
Cumulative share2 missions
Payer Claims·ExpertPlan-type adverse selection: high-utilizer concentration (NTILE × cumulative %)Mission 20 →Finance·HardRevenue concentration — customer ParetoMission 17 →
Data quality audit2 missions
Marketing·ExpertFix the product category messMission 22 →BI·StarterThe dashboard numbers don't add upMission 5 →
Date extract2 missions
Logistics & Transportation Analytics·MediumMonthly shipment volume trendMission 11 →Procurement & Sourcing Analytics·ExpertPPV walk by monthMission 22 →
Date extraction2 missions
Provider·HardMonth-over-month encounter trendMission 18 →Finance·MediumRevenue seasonality by monthMission 13 →
Date-window predicate2 missions
Clinical Trials·MasterAdverse-event temporal cluster detectionMission 23 →Pharma Commercial·ExpertMulti-touch attribution — sample-call vs plain-call → RxMission 19 →
Dedup2 missions
RevOps·HardMost recent opportunity per accountMission 16 →E-commerce·HardMost recent order per customerMission 16 →
Dim audit2 missions
Operations·StarterHow many SKUs do we stock?Mission 3 →Operations·StarterList our SKU categoriesMission 4 →
Executive summary2 missions
Banking·ExpertPortfolio risk scorecard capstoneMission 25 →Banking·MasterProduct portfolio risk summaryMission 29 →
EXISTS2 missions
Retail Banking Operations·MediumPrimary banking relationship classificationMission 8 →Consumer Lending Analyst·HardRefi candidate cohortMission 18 →
Filtering2 missions
Finance·HardCost center rank by 2025 OpExMission 19 →AML & Fraud·ExpertCTR / SAR filing candidate listMission 22 →
Grain reasoning2 missions
BI·ExpertWhy is our leaderboard off by 12x?Mission 26 →Banking·StarterCustomer vs account — know the grainMission 5 →
GROUP BY derived expression2 missions
Pharma Commercial·MediumQuarterly call volume trendMission 8 →Hospital RCM·MediumMonthly claim volume trendMission 8 →
GROUP BY multi-key2 missions
Payer Claims·MediumAvg paid_amt by plan_type × fundingMission 7 →Payer Claims·MediumCARC code frequency × categoryMission 8 →
HHI2 missions
Finance·MasterYear-end FP&A capstone — board KPI panelMission 30 →Operations·MasterSupplier concentration risk per category (Herfindahl index)Mission 29 →
History table2 missions
RevOps·MediumDeals that reopened after Closed-WonMission 11 →RevOps·HardPoint-in-time forecast snapshot (SCD2)Mission 17 →
IN clause2 missions
Pharma Commercial·ExpertSwitcher cohort — competitor-pre-launch to Cardiozin-post-launchMission 17 →Hospital RCM·EasyMedicare patients by demographicMission 2 →
LEFT JOIN anti-join2 missions
Pharma Commercial·MasterData quality audit — orphan NPIs + NULL plan_ids in one reportMission 24 →Hospital RCM·MasterData quality audit — orphan claims + NULL denials in one reportMission 24 →
LEFT JOIN audit2 missions
Clinical Ops·HardCoding shift detectionMission 15 →Clinical Ops·MasterData quality audit — POA gaps and legacy codesMission 24 →
LEFT JOIN with COALESCE2 missions
Pharma Commercial·ExpertHCP×product call-Rx ROI matrixMission 16 →Hospital RCM·ExpertProvider × CPT productivity matrixMission 16 →
LOWER()2 missions
Provider·MediumReadmission rate by insurance typeMission 13 →Provider·HardRank specialties by encounter volumeMission 16 →
MAX(CASE) pivot2 missions
Clinical Trials·ExpertDrug vs placebo AE rate delta — paired per-arm comparisonMission 19 →Payer Claims·ExpertOverturn% by level × denial_category (MAX(CASE) pivot)Mission 16 →
Multi-CTE pivot2 missions
Retail Banking Operations·MasterDeposit beta by product subcategoryMission 27 →Consumer Lending Analyst·MasterALCO portfolio stratification dashboardMission 27 →
Multi-finding audit2 missions
Pharma Commercial·MasterData quality audit — orphan NPIs + NULL plan_ids in one reportMission 24 →Hospital RCM·MasterData quality audit — orphan claims + NULL denials in one reportMission 24 →
NTILE on aggregate2 missions
Pharma Commercial·ExpertPersistence quartiles — NTILE on per-HCP Cardiozin fill countsMission 20 →Hospital RCM·ExpertAR cohort persistence quartiles — claim-to-payment lag distributionMission 20 →
NTILE()2 missions
BI·ExpertPercentile ranking across the sales forceMission 24 →Finance·ExpertCost-center percentile rankingMission 24 →
Parallel CTEs2 missions
Marketing·MasterMulti-touch attribution — last-click vs first-click vs linearMission 27 →E-commerce·MasterMulti-touch attribution — last-click vs first-click vs linearMission 27 →
Parallel KPIs2 missions
Pharma Commercial·MasterBrand performance scorecard — every product, every metricMission 21 →Hospital RCM·MasterRCM scorecard — every payer, every KPIMission 21 →
Parallel NTILE/RANK windows2 missions
Pharma Commercial·MasterHCP segmentation capstone — multi-metric ranks + decile recompute + segment labelMission 25 →Hospital RCM·MasterPatient revenue segmentation capstone — multi-metric ranks + segment labelMission 25 →
PERCENT_RANK()2 missions
BI·ExpertPercentile ranking across the sales forceMission 24 →Finance·ExpertCost-center percentile rankingMission 24 →
Percentile2 missions
Warehouse Operations Analytics·ExpertPercentile distributionMission 23 →Warehouse Operations Analytics·MasterDC capstoneMission 30 →
Persistence proxy2 missions
Pharma Commercial·ExpertPersistence quartiles — NTILE on per-HCP Cardiozin fill countsMission 20 →Hospital RCM·ExpertAR cohort persistence quartiles — claim-to-payment lag distributionMission 20 →
Priority CASE2 missions
Pharma Commercial·MasterHCP segmentation capstone — multi-metric ranks + decile recompute + segment labelMission 25 →Hospital RCM·MasterPatient revenue segmentation capstone — multi-metric ranks + segment labelMission 25 →
RANK2 missions
Banking·MasterChargeback risk score by merchant categoryMission 28 →AML & Fraud·MasterRule precision scorecard with rankMission 28 →
Ratios2 missions
AML & Fraud·EasyWire vs cash — volume by channel groupMission 10 →AML & Fraud·ExpertRule-tuning backtest — precision quadrantsMission 24 →
Reconciliation2 missions
E-commerce·HardShopify vs Stripe reconciliationMission 17 →E-commerce·HardGA4 conversion-value vs Shopify revenueMission 19 →
Retention2 missions
RevOps·HardClosed-Won cohort retention by monthMission 18 →E-commerce·HardRepeat-purchase cohort retentionMission 18 →
ROW_NUMBER window2 missions
Clinical Ops·MasterHCC chronic burden — patient risk tiering capstoneMission 25 →Clinical Trials·HardFirst adverse event per enrollmentMission 11 →
ROW_NUMBER()2 missions
BI·MediumRank the sales teamMission 11 →BI·HardTop 2 products per categoryMission 16 →
Schema exploration2 missions
RevOps·StarterMeet the opportunities tableMission 1 →E-commerce·StarterMeet the orders tableMission 1 →
Scoring2 missions
AML & Fraud·ExpertSanctions-list fuzzy match scorecardMission 23 →RevOps·ExpertPipeline hygiene — issue count per opportunityMission 21 →
SELECT *2 missions
Operations·StarterShow me the warehousesMission 2 →Logistics & Transportation Analytics·StarterFirst look at the shipment rosterMission 1 →
Set arithmetic2 missions
Retail Banking Operations·StarterNet new checking accounts this weekMission 5 →Consumer Lending Analyst·StarterNet new mortgages last 30 daysMission 5 →
substr date2 missions
Pharma Commercial·MediumQuarterly call volume trendMission 8 →Hospital RCM·MediumMonthly claim volume trendMission 8 →
SUM() OVER2 missions
BI·HardRunning revenue total by monthMission 20 →Finance·MediumRunning cash burnMission 15 →
SUM(CASE)2 missions
Pharma Commercial·MediumNRx vs TRx breakdown per productMission 7 →Hospital RCM·MediumClean claim rate per payerMission 7 →
SUM(POWER(share,2))2 missions
Clinical Trials·ExpertSite HHI — concentration of enrollments per therapeutic areaMission 18 →Payer Claims·HardTop denial concentration via HHI on CARC codesMission 12 →
SUM(share*share)2 missions
Pharma Commercial·ExpertTerritory market share HHI — concentration of Rx volumeMission 18 →Hospital RCM·ExpertPayer concentration HHI per service lineMission 18 →
TEXT alignment2 missions
Retail Banking Operations·MasterTreasury daily liquidity dashboardMission 29 →Consumer Lending Analyst·MasterCECL-style loss reserve decompositionMission 29 →
Threshold filter2 missions
Hospital RCM·HardUnderpayment detection — contracted vs paidMission 14 →Operations·MediumOverstocked SKUs (over 15 days of supply)Mission 15 →
Two-fact join at grain2 missions
Pharma Commercial·MasterBrand performance scorecard — every product, every metricMission 21 →Hospital RCM·MasterRCM scorecard — every payer, every KPIMission 21 →
UNION ALL events2 missions
Pharma Commercial·HardCall-to-Rx attribution lag — LAG window across event streamsMission 15 →Hospital RCM·HardClaim-to-remit lag — LAG window across event streamsMission 15 →
Variance2 missions
Finance·MediumOverspend flags — actuals vs budgetMission 12 →Banking·ExpertChampion–challenger collections backtestMission 24 →
Window2 missions
Retail Banking Operations·MediumDeposit beta on MMAs (cycle-to-date)Mission 11 →RevOps·HardQuarterly bookings waterfall — new vs expandMission 19 →
Window frames2 missions
Provider·ExpertThe CMS Quality DashboardMission 25 →AML & Fraud·ExpertStructuring ring capstone — everyone in the networkMission 21 →
Window functions on CTE2 missions
Marketing·MasterMulti-touch attribution — last-click vs first-click vs linearMission 27 →E-commerce·MasterMulti-touch attribution — last-click vs first-click vs linearMission 27 →
YoY2 missions
BI·ExpertYear-over-year revenue by quarterMission 21 →Finance·HardYoY revenue growth by monthMission 18 →
% calc1 mission
Clinical Ops·HardPOA documentation rate by codeMission 12 →
% change1 mission
Provider·HardMonth-over-month encounter trendMission 18 →
100.0 * float promotion1 mission
Clinical Trials·MediumAdherence rate per enrollmentMission 7 →
2-D bucketing1 mission
Banking·MasterCharge-off rate by product — FICO band heatmapMission 26 →
2-table aggregation1 mission
Clinical Trials·EasyEnrollments per siteMission 2 →
2-table SELECT1 mission
Clinical Ops·MediumTranslate every diagnosis on the chartMission 6 →
8-KPI panel1 mission
Consumer Lending Analyst·MasterLending capstone scorecard (8-KPI single-row panel)Mission 30 →
A/B framing1 mission
Banking·ExpertChampion–challenger collections backtestMission 24 →
ABS1 mission
Operations·MediumForecast accuracy by SKU last weekMission 13 →
Active filtering1 mission
BI·StarterWho is hitting their sales targets?Mission 2 →
Active-book filter1 mission
Consumer Lending Analyst·ExpertDelinquency aging bucket pivot by productMission 21 →
Advanced analytics1 mission
BI·ExpertThe executive summary queryMission 25 →
AE rate per 1001 mission
Clinical Trials·MasterMulti-phase safety signal — phase 3 vs phase 2 by therapeutic areaMission 22 →
Aggregate-then-divide1 mission
Operations·MediumForecast accuracy by SKU last weekMission 13 →
Aggregate-then-window1 mission
Finance·MasterCash burn waterfall — monthly net + cumulative runwayMission 27 →
Algebraic decomposition1 mission
BI·MasterYoY revenue decomposition — price vs volumeMission 27 →
Ambiguity1 mission
Marketing·EasyCount unique customersMission 6 →
Anti-join (IS NULL)1 mission
Clinical Ops·MediumOrphan codes — codebook gapsMission 10 →
Arithmetic1 mission
Logistics & Transportation Analytics·MediumOverbilled invoicesMission 14 →
Asymmetric cohort filter1 mission
Clinical Ops·ExpertAcute MI bundleMission 19 →
Attainment1 mission
BI·StarterWho is hitting their sales targets?Mission 2 →
Attainment %1 mission
RevOps·MediumQuota attainment by rep (2025-Q1)Mission 31 →
Audit report1 mission
BI·MasterDirty-dim audit — category casing reconciliationMission 29 →
Audit trail1 mission
Finance·EasyUn-posted journal auditMission 8 →
AVG decomposition1 mission
Operations·ExpertForecast accuracy decomposition (bias + precision per SKU)Mission 24 →
AVG fills/span1 mission
Pharma Commercial·MasterRx adherence proxy — fills per HCP×product across therapeutic classMission 23 →
AVG lag1 mission
Hospital RCM·MasterPayment-timing proxy across payer mixMission 23 →
AVG LOS1 mission
Clinical Ops·MasterCCSR service-line rollupMission 23 →
AVG over window1 mission
Retail Banking Operations·MediumAverage daily balance for fee waiversMission 13 →
AVG with NULL filter1 mission
Clinical Trials·MediumAverage visit drift by siteMission 9 →
AVG() OVER()1 mission
Provider·HardED wait times by day of weekMission 17 →
AVG/MIN/MAX1 mission
Operations·MediumLead-time consistency per supplierMission 14 →
Baseline-relative flag1 mission
Banking·MasterChargeback risk score by merchant categoryMission 28 →
Behavioral targeting1 mission
Retail Banking Operations·ExpertTier-break top-up candidates (Savings/MMA)Mission 22 →
Boolean aggregation1 mission
Clinical Trials·EasyVisit completion vs no-showMission 4 →
Boolean filters1 mission
Clinical Ops·EasyPull the chronic disease listMission 2 →
Bracket math1 mission
RevOps·MasterComp accelerator math (2025-Q1)Mission 33 →
Budget vs actual1 mission
Finance·MediumMarch budget-variance checkMission 11 →
Capacity-normalized metric1 mission
Clinical Trials·HardSite rank by enrollment velocityMission 14 →
CASE + AVG1 mission
Operations·EasyOn-time delivery rate per supplierMission 7 →
CASE labels1 mission
Operations·MasterSupplier health capstone (multi-CTE scorecard)Mission 26 →
Case triage1 mission
AML & Fraud·MasterMulti-signal customer risk scoreMission 26 →
CASE WHEN inside COUNT1 mission
Clinical Ops·HardEncounter complexity score — top 10Mission 14 →
Cash flow1 mission
Finance·MasterCash burn waterfall — monthly net + cumulative runwayMission 27 →
Casing normalization1 mission
Operations·EasyTotal units ordered per category last quarterMission 6 →
Category normalization1 mission
BI·StarterProduct mix is shiftingMission 3 →
CCSR rollup1 mission
Clinical Ops·MasterCCSR service-line rollupMission 23 →
CECL grid1 mission
Banking·MasterCharge-off rate by product — FICO band heatmapMission 26 →
Channel mix1 mission
AML & Fraud·MasterCash-intensive customer profileMission 27 →
COALESCE chain1 mission
Operations·ExpertPoint-in-time supplier on-time target (SCD2 reconstruction)Mission 21 →
COALESCE fallback1 mission
RevOps·MasterDiscount slippage by close-quarterMission 26 →
Codebook audit1 mission
Clinical Ops·MediumOrphan codes — codebook gapsMission 10 →
Cohort analysis1 mission
BI·ExpertHire cohort performance analysisMission 23 →
Cohort cross-tab1 mission
Payer Claims·MediumMember denial-rate cohort by regionMission 9 →
Cohort definition1 mission
Retail Banking Operations·Hard2025 closed-account exit cohort with tenureMission 18 →
Cohort intersection (INNER JOIN)1 mission
Clinical Ops·ExpertDiabetic kidney disease cohortMission 17 →
Cohort logic1 mission
Finance·ExpertVendor spend — new vs. recurringMission 22 →
Cohort LTV1 mission
Marketing·MasterLTV decomposition by acquisition channelMission 28 →
Cohort seasoning1 mission
Consumer Lending Analyst·HardEarly-Payment Default rate by vintage monthMission 16 →
Cohort start1 mission
Payer Claims·MasterMember retention proxy: enrollment-cohort decayMission 24 →
Comp join1 mission
RevOps·MasterClawback exposure on reopened dealsMission 34 →
Comparison1 mission
BI·EasyFind reps outselling their department averageMission 8 →
Composable metric assembly1 mission
Clinical Trials·MasterTrial portfolio scorecard — every trial, every metricMission 21 →
Composite metrics1 mission
Operations·HardSupplier scorecard (lead time + on-time + cancellation)Mission 17 →
Composite scoring1 mission
Payer Claims·MasterProvider scorecard composite, percentile-bandedMission 23 →
Composition1 mission
BI·MasterTenure-adjusted attainment scorecardMission 28 →
Comprehensive report1 mission
Provider·ExpertDepartment scorecardMission 24 →
Computed gap1 mission
Operations·ExpertReorder-point breach: SKUs below their ROPMission 25 →
Computed metric1 mission
Operations·EasyTop 5 SKUs by purchase valueMission 8 →
Computed ratio1 mission
Operations·HardInventory turnover ratio (last week)Mission 20 →
Conditional MAX pivot1 mission
Consumer Lending Analyst·MasterFair Lending disparity index by FICO band (Black vs White)Mission 26 →
Conditional ratio1 mission
Consumer Lending Analyst·MediumLate-payment rate by vintage monthMission 15 →
Confusion matrix1 mission
AML & Fraud·ExpertRule-tuning backtest — precision quadrantsMission 24 →
Conversion rates1 mission
Payer Claims·MasterEnd-to-end claim lifecycle funnelMission 21 →
Correlated subqueries1 mission
BI·HardCorrelated check: reps beating their own averageMission 19 →
Cost allocation1 mission
Finance·MasterVariance bridge with allocation overlayMission 26 →
COUNT FILTER1 mission
Clinical Ops·MasterData quality audit — POA gaps and legacy codesMission 24 →
COUNT(*) FILTER1 mission
Clinical Trials·ExpertHigh-risk cohort — active enrollments with multiple SAEs or grade-5 AEMission 17 →
COUNT(DISTINCT) anti-inflation1 mission
Clinical Trials·MasterMulti-phase safety signal — phase 3 vs phase 2 by therapeutic areaMission 22 →
COUNT(fact.pk) trap1 mission
Pharma Commercial·MediumRep call activity vs target — surface zero-call repsMission 10 →
Counterfactual1 mission
AML & Fraud·HardFalse positives by rule — tuning targetsMission 19 →
CROSS JOIN1 mission
AML & Fraud·MasterSanctions fuzzy match scorecardMission 29 →
CROSS JOIN of CTE singletons1 mission
Retail Banking Operations·MasterRetail Ops capstone scorecardMission 30 →
CROSS JOIN of scalar CTEs1 mission
Consumer Lending Analyst·MasterLending capstone scorecard (8-KPI single-row panel)Mission 30 →
Cross-join baseline1 mission
Provider·MasterHRRP-style readmission penalty exposureMission 28 →
Cross-phase paired pivot1 mission
Clinical Trials·MasterMulti-phase safety signal — phase 3 vs phase 2 by therapeutic areaMission 22 →
Cross-product aggregation1 mission
Retail Banking Operations·HardLoan-to-Deposit ratio by regionMission 19 →
Cross-tab via JOIN1 mission
Clinical Ops·ExpertComorbidity co-occurrence matrixMission 16 →
CTCAE severity1 mission
Clinical Trials·EasyAdverse events by severity gradeMission 5 →
CTE bridge1 mission
Provider·MasterPatient satisfaction × readmission gap by departmentMission 29 →
CTE filtering1 mission
Clinical Ops·HardTop 3 codes per body systemMission 11 →
CTEs1 mission
Marketing·ExpertThe full campaign scorecardMission 25 →
CTR threshold1 mission
AML & Fraud·StarterCash deposits over $10KMission 5 →
Cumulative1 mission
Banking·HardVintage curve — 90+ DPD by MOBMission 16 →
Cumulative aggregate1 mission
Clinical Trials·HardRunning enrollment by monthMission 12 →
Cumulative distribution1 mission
Banking·ExpertKS statistic on PD model scoresMission 22 →
Cumulative loss1 mission
Banking·ExpertCECL lifetime loss projection by vintageMission 23 →
Cumulative metric1 mission
Payer Claims·HardRolling 90-day denial trendMission 13 →
Cumulative ratio1 mission
Consumer Lending Analyst·ExpertCumulative loss curve by vintage × months-to-charge-offMission 25 →
Customer attribute join1 mission
Retail Banking Operations·ExpertDeposit balance by acquisition channelMission 21 →
Cutoff testing1 mission
Finance·MasterLate-posting impact on monthly totalsMission 29 →
CV math1 mission
Operations·MasterDemand stability per SKU (coefficient of variation)Mission 28 →
Daily-balance × rate aggregation1 mission
Retail Banking Operations·HardMonthly interest income by product categoryMission 16 →
Data cleaning1 mission
Marketing·HardNormalize the gender messMission 18 →
Date cohorts1 mission
Finance·ExpertVendor onboarding cohortsMission 23 →
Date parsing1 mission
BI·StarterBoard deck needs revenue by quarterMission 1 →
Date range1 mission
Finance·StarterMarch 2025 expense rollupMission 5 →
Date range filter1 mission
Payer Claims·EasyDenied claims this quarterMission 5 →
Date range frame1 mission
Payer Claims·HardRolling 90-day denial trendMission 13 →
Date scope1 mission
Operations·EasyLate shipments this quarterMission 10 →
Date window predicate1 mission
Payer Claims·ExpertSliding-window repeat-denial detection (LAG within member-CPT)Mission 19 →
Date-window split1 mission
Pharma Commercial·ExpertSwitcher cohort — competitor-pre-launch to Cardiozin-post-launchMission 17 →
Decay curve1 mission
Payer Claims·MasterMember retention proxy: enrollment-cohort decayMission 24 →
Deduplication1 mission
Marketing·ExpertSomething's off with our numbersMission 21 →
Denominator selection1 mission
Clinical Trials·MasterTrial portfolio scorecard — every trial, every metricMission 21 →
Denormalization1 mission
BI·HardThree-table join: who sold what where?Mission 18 →
Diffs1 mission
E-commerce·HardShopify vs Stripe reconciliationMission 17 →
Dim preview1 mission
Operations·StarterShow me the warehousesMission 2 →
Dim quality1 mission
BI·MasterDirty-dim audit — category casing reconciliationMission 29 →
Dimension filter1 mission
Clinical Trials·MediumPhase-3 trial rosterMission 8 →
Dirty data1 mission
RevOps·MediumDeals that reopened after Closed-WonMission 11 →
Distance calc1 mission
Banking·HardSame-day amount-swing flagMission 19 →
DISTINCT in CTE1 mission
Clinical Ops·ExpertDiabetic kidney disease cohortMission 17 →
Distribution decomposition1 mission
Provider·MasterLength-of-stay quartiles by departmentMission 27 →
Division1 mission
Marketing·MediumWhich campaign has the best ROI?Mission 12 →
Drop-off attribution1 mission
RevOps·MasterStage conversion funnel with drop-offMission 27 →
Dual threshold flag1 mission
AML & Fraud·MasterCash-intensive customer profileMission 27 →
Eligibility scoring1 mission
Retail Banking Operations·HardCross-sell candidate model: cash-back cardMission 20 →
Encounter pivot1 mission
Clinical Ops·HardCoding shift detectionMission 15 →
Excess vs deficit1 mission
Operations·MasterMulti-warehouse rebalancing planMission 27 →
Excess-vs-baseline1 mission
Provider·MasterHRRP-style readmission penalty exposureMission 28 →
EXISTS / NOT EXISTS1 mission
Retail Banking Operations·HardCross-sell candidate model: cash-back cardMission 20 →
Expansion lens1 mission
RevOps·MasterAccount expansion analysis — multi-opp customersMission 29 →
Exposure x loss1 mission
Banking·MasterProduct portfolio risk summaryMission 29 →
EXTRACT(DOW)1 mission
Provider·HardED wait times by day of weekMission 17 →
Fact-to-fact bridge1 mission
Clinical Trials·MediumAverage visit drift by siteMission 9 →
Fan-out1 mission
BI·ExpertWhy is our leaderboard off by 12x?Mission 26 →
FDIC limit logic1 mission
Retail Banking Operations·ExpertFDIC insurance bucket stress testMission 23 →
Filter on CARC code1 mission
Payer Claims·HardCPT bundling (CO-97) leakage by providerMission 14 →
Filter on level1 mission
Payer Claims·MediumFirst-pass appeal volume by levelMission 10 →
First-per-group1 mission
Clinical Trials·HardFirst adverse event per enrollmentMission 11 →
First-seen1 mission
Finance·ExpertVendor spend — new vs. recurringMission 22 →
First-touch attribution1 mission
Marketing·MasterLTV decomposition by acquisition channelMission 28 →
forecast_category1 mission
RevOps·HardForecast category pivot — per repMission 32 →
Format handling1 mission
Provider·MediumPatient age at admissionMission 15 →
FTP curve join1 mission
Retail Banking Operations·MasterBranch-level P&L with FTP overlayMission 26 →
Full report1 mission
Marketing·ExpertThe full campaign scorecardMission 25 →
Fully-loaded variance1 mission
Finance·MasterVariance bridge with allocation overlayMission 26 →
Funnel1 mission
E-commerce·ExpertAbandoned-cart funnel by sourceMission 23 →
FX normalization1 mission
E-commerce·MasterFX-adjusted net revenue per channelMission 29 →
Gap detection1 mission
Payer Claims·MasterNetwork adequacy gap: specialty × regionMission 25 →
Generated time-points1 mission
Payer Claims·MasterMember retention proxy: enrollment-cohort decayMission 24 →
Generated time-points CROSS JOIN1 mission
Clinical Trials·MasterPatient retention curve — Kaplan-Meier-style step functionMission 24 →
Geographic analysis1 mission
Marketing·MediumRevenue by stateMission 14 →
GROUP BY AVG1 mission
Operations·MediumAverage lead time per supplierMission 11 →
GROUP BY flag1 mission
Clinical Trials·EasyVisit completion vs no-showMission 4 →
GROUP BY provider1 mission
Payer Claims·HardCPT bundling (CO-97) leakage by providerMission 14 →
GROUP_CONCAT1 mission
BI·MasterDirty-dim audit — category casing reconciliationMission 29 →
Growth1 mission
BI·MediumMonthly revenue trend with growth rateMission 13 →
HAVING aggregate filter1 mission
Clinical Trials·MasterAdverse-event temporal cluster detectionMission 23 →
HAVING COUNT = 01 mission
Operations·HardStockout root cause: SKUs with no incoming POMission 19 →
HAVING COUNT(DISTINCT)1 mission
Clinical Ops·HardEncounters carrying multiple HCCsMission 13 →
HAVING multi-event1 mission
RevOps·MasterAccount expansion analysis — multi-opp customersMission 29 →
HAVING threshold1 mission
Hospital RCM·MediumDenial rate per CPT — high-volume CPTs onlyMission 9 →
HAVING vs WHERE1 mission
Pharma Commercial·HardHigh-NRx-share prescribers — HAVING thresholdMission 12 →
Hierarchy1 mission
BI·MediumWho reports to whom?Mission 12 →
Histogram1 mission
Retail Banking Operations·MediumRate-tier balance distributionMission 12 →
Historical rate × open denials1 mission
Payer Claims·MasterRecoverable revenue at historical overturn rateMission 22 →
History1 mission
RevOps·MediumStage regressions — deals that moved backwardMission 12 →
History funnel1 mission
RevOps·MasterStage conversion funnel with drop-offMission 27 →
Inequality filter1 mission
Operations·EasyLate shipments this quarterMission 10 →
Inline rates CTE1 mission
E-commerce·MasterFX-adjusted net revenue per channelMission 29 →
INTERSECT1 mission
BI·MasterSame-rep regional growth — apples-to-apples YoYMission 30 →
INTERVAL1 mission
Marketing·HardIs our email actually working?Mission 16 →
Investigation1 mission
BI·StarterThe dashboard numbers don't add upMission 5 →
is_target filter1 mission
Pharma Commercial·ExpertHCP×product call-Rx ROI matrixMission 16 →
JOIN to dim1 mission
Operations·EasyStock-out risk: SKUs with under 7 days of supplyMission 9 →
LAG PARTITION BY1 mission
Provider·ExpertTop diagnoses year-over-yearMission 23 →
Latest-snapshot pattern1 mission
Operations·MediumLatest inventory on hand per warehouseMission 12 →
Latest-snapshot pivot1 mission
Retail Banking Operations·ExpertDeposit balance by acquisition channelMission 21 →
Latest-snapshot range filter1 mission
Retail Banking Operations·ExpertTier-break top-up candidates (Savings/MMA)Mission 22 →
LEAST scenario operator1 mission
Retail Banking Operations·MasterNSF/OD fee cap scenario by FICO bandMission 28 →
LEAST/GREATEST1 mission
RevOps·MasterComp accelerator math (2025-Q1)Mission 33 →
LEFT JOIN + COALESCE1 mission
Clinical Trials·MediumSAE rate per siteMission 10 →
LEFT JOIN + IS NULL1 mission
Payer Claims·ExpertOON leakage cohort (anti-join)Mission 17 →
LEFT JOIN counting trap1 mission
Clinical Trials·HardSite rank by enrollment velocityMission 14 →
LEFT JOIN denominator1 mission
Clinical Trials·ExpertAE attribution matrix — intervention × severityMission 16 →
LEFT JOIN spine1 mission
BI·MasterSame-rep regional growth — apples-to-apples YoYMission 30 →
LEVENSHTEIN1 mission
AML & Fraud·ExpertSanctions-list fuzzy match scorecardMission 23 →
LIKE1 mission
AML & Fraud·HardEmail reuse — fuzzy entity resolutionMission 16 →
LIKE pattern families1 mission
Clinical Ops·ExpertDiabetic kidney disease cohortMission 17 →
MAPE1 mission
Operations·MediumForecast accuracy by SKU last weekMission 13 →
Match scoring1 mission
AML & Fraud·MasterSanctions fuzzy match scorecardMission 29 →
Member-to-provider ratio1 mission
Payer Claims·MasterNetwork adequacy gap: specialty × regionMission 25 →
MIN1 mission
Provider·EasyED wait time overviewMission 8 →
MIN-aggregation cohort1 mission
Consumer Lending Analyst·HardDelinquency progression: first miss × current statusMission 19 →
Modulo1 mission
AML & Fraud·MediumRound-dollar wires — flag a patternMission 11 →
Monthly bin1 mission
Operations·ExpertLead-time trend per supplier (monthly average)Mission 22 →
Moving average1 mission
BI·ExpertThree-month moving averageMission 22 →
Multi-branch CASE1 mission
Retail Banking Operations·ExpertReg E dispute aging reportMission 24 →
Multi-column ORDER BY1 mission
Clinical Ops·EasyThe HCC-eligible code listMission 3 →
Multi-condition1 mission
Consumer Lending Analyst·HardRefi candidate cohortMission 18 →
Multi-condition CASE1 mission
Retail Banking Operations·ExpertFDIC insurance bucket stress testMission 23 →
Multi-condition filter1 mission
Pharma Commercial·HardHigh-NRx-share prescribers — HAVING thresholdMission 12 →
Multi-COUNT DISTINCT1 mission
Clinical Ops·HardEncounter complexity score — top 10Mission 14 →
Multi-criteria ranking1 mission
Retail Banking Operations·HardBranch consolidation candidate scoreMission 17 →
Multi-criteria scoring1 mission
Clinical Trials·MasterSponsor performance benchmark — multi-metric ranksMission 25 →
Multi-CTE funnel1 mission
Payer Claims·MasterEnd-to-end claim lifecycle funnelMission 21 →
Multi-CTE scenario1 mission
Consumer Lending Analyst·MasterRate-shock stress test on ARM payments (+200bp)Mission 28 →
Multi-fact join1 mission
Operations·HardInventory turnover ratio (last week)Mission 20 →
Multi-metric rollup1 mission
Payer Claims·MasterProvider scorecard composite, percentile-bandedMission 23 →
Multi-system join1 mission
E-commerce·HardShopify vs Stripe reconciliationMission 17 →
Multi-system reconciliation1 mission
E-commerce·MasterGA4 vs Shopify drift forensicsMission 28 →
Multi-table JOIN chain1 mission
Hospital RCM·EasyTotal payments per providerMission 5 →
Multi-technique1 mission
BI·ExpertThe executive summary queryMission 25 →
Multiple CTEs1 mission
Provider·ExpertDepartment scorecardMission 24 →
NDR proxy1 mission
RevOps·MasterAccount expansion analysis — multi-opp customersMission 29 →
Negative amounts1 mission
Finance·MediumRefund leakage — net revenue impactMission 14 →
Net revenue1 mission
E-commerce·MediumRefund-aware net revenue by monthMission 15 →
Normalization1 mission
Marketing·HardClean up the traffic sourcesMission 17 →
NOT EXISTS1 mission
BI·HardFind products with no sales last quarterMission 17 →
NOT IN1 mission
Marketing·HardHow many customers opened zero emails?Mission 20 →
NTILE bands1 mission
Payer Claims·MasterProvider scorecard composite, percentile-bandedMission 23 →
NTILE deciles1 mission
Payer Claims·ExpertPlan-type adverse selection: high-utilizer concentration (NTILE × cumulative %)Mission 20 →
NTILE quartile1 mission
BI·MasterTenure-adjusted attainment scorecardMission 28 →
NTILE() per partition1 mission
Provider·MasterLength-of-stay quartiles by departmentMission 27 →
NTILE(10) window1 mission
Pharma Commercial·HardDecile-based prescriber tiers — recompute from Rx volumeMission 11 →
NULL as a value1 mission
Clinical Ops·EasyThe POA tallyMission 5 →
NULL filter1 mission
Operations·MediumAverage lead time per supplierMission 11 →
NULL filtering1 mission
Marketing·EasyWhich coupon is pulling its weight?Mission 7 →
NULL-before-window filter1 mission
Clinical Trials·ExpertAdherence quartiles × outcome — NTILE × status pivotMission 20 →
NULL-safe sequential comparison1 mission
Clinical Trials·HardVisit drift trend per enrollmentMission 15 →
NULLIF div-by-zero guard1 mission
Clinical Trials·HardScreen-fail rate vs portfolio averageMission 13 →
NULLIF for div-by-zero1 mission
Clinical Ops·ExpertDiagnosis chronicity ladderMission 20 →
OFAC screen1 mission
AML & Fraud·MasterSanctions fuzzy match scorecardMission 29 →
OR cohort with parens1 mission
Clinical Trials·ExpertHigh-risk cohort — active enrollments with multiple SAEs or grade-5 AEMission 17 →
OR logic1 mission
Provider·EasyProvider roster with red flagsMission 10 →
OR-of-LIKEs1 mission
Clinical Ops·ExpertAcute MI bundleMission 19 →
ORDER BY ASC1 mission
Clinical Trials·EasyAdverse events by severity gradeMission 5 →
Outer join1 mission
E-commerce·MasterGA4 vs Shopify drift forensicsMission 28 →
Pair grain1 mission
Hospital RCM·ExpertProvider × CPT productivity matrixMission 16 →
Pair grain → class grain1 mission
Pharma Commercial·MasterRx adherence proxy — fills per HCP×product across therapeutic classMission 23 →
Pair grain → payer grain1 mission
Hospital RCM·MasterPayment-timing proxy across payer mixMission 23 →
Paired-comparison shape1 mission
Clinical Trials·ExpertDrug vs placebo AE rate delta — paired per-arm comparisonMission 19 →
Parallel RANK windows1 mission
Clinical Trials·MasterSponsor performance benchmark — multi-metric ranksMission 25 →
Pareto1 mission
Operations·ExpertABC analysis: classify SKUs by spend shareMission 23 →
PARTITION BY department1 mission
Hospital RCM·HardTop denial reason per department — RANK PARTITIONMission 13 →
PARTITION BY member-CPT1 mission
Payer Claims·ExpertSliding-window repeat-denial detection (LAG within member-CPT)Mission 19 →
PARTITION BY product1 mission
Pharma Commercial·HardCopay distribution per product — NTILE(4) quartilesMission 13 →
PARTITION BY specialty1 mission
Payer Claims·ExpertProvider appeal-success ranking within specialty (RANK PARTITION)Mission 18 →
PARTITION BY territory1 mission
Pharma Commercial·HardTop product per territory — RANK PARTITIONMission 14 →
Patient-level aggregation1 mission
Provider·MasterPatient satisfaction × readmission gap by departmentMission 29 →
Peek query1 mission
Operations·StarterHow many suppliers do we work with?Mission 1 →
Penalty model1 mission
Provider·MasterHRRP-style readmission penalty exposureMission 28 →
Per-branch NII pivot1 mission
Retail Banking Operations·MasterBranch-level P&L with FTP overlayMission 26 →
Per-encounter ratio1 mission
Clinical Ops·ExpertDiagnosis chronicity ladderMission 20 →
Per-enrollment summary CTE1 mission
Clinical Trials·ExpertHigh-risk cohort — active enrollments with multiple SAEs or grade-5 AEMission 17 →
Per-product pivot1 mission
Banking·MasterProduct portfolio risk summaryMission 29 →
Per-provider rate1 mission
Payer Claims·HardCPT bundling (CO-97) leakage by providerMission 14 →
Per-region pivot1 mission
RevOps·HardRegional pipeline scorecardMission 28 →
Per-region rate1 mission
Payer Claims·MediumMember denial-rate cohort by regionMission 9 →
Per-row delta1 mission
Clinical Trials·HardVisit drift trend per enrollmentMission 15 →
Per-row ratio1 mission
Clinical Trials·MediumAdherence rate per enrollmentMission 7 →
PERCENT_RANK1 mission
Finance·HardRevenue concentration — customer ParetoMission 17 →
Percentile bucketing1 mission
Payer Claims·HardAppeals TAT percentiles by level (NTILE)Mission 15 →
Period math1 mission
RevOps·ExpertARR bridge — starting + new + expand per quarterMission 22 →
Period-over-period1 mission
Operations·HardDemand week-over-week changeMission 18 →
Pivot via conditional aggregation1 mission
Clinical Trials·ExpertAdherence quartiles × outcome — NTILE × status pivotMission 20 →
Point-in-time1 mission
Banking·HardQuarter-end balance snapshot (Y-9C style)Mission 20 →
Population stability1 mission
Banking·ExpertPSI — score distribution vs baselineMission 21 →
Posted flag1 mission
Finance·EasyUn-posted journal auditMission 8 →
POWER amortization1 mission
Consumer Lending Analyst·MasterRate-shock stress test on ARM payments (+200bp)Mission 28 →
Pre-aggregated CTEs1 mission
BI·ExpertWhy is our leaderboard off by 12x?Mission 26 →
Price effect1 mission
BI·MasterYoY revenue decomposition — price vs volumeMission 27 →
Primary vs authorized1 mission
Banking·EasyJoint accounts — who’s the primary?Mission 10 →
Principal+any-rank1 mission
Clinical Ops·ExpertAcute MI bundleMission 19 →
Priority bucketing1 mission
Pharma Commercial·ExpertMulti-touch attribution — sample-call vs plain-call → RxMission 19 →
Priority resolution1 mission
Hospital RCM·ExpertEdit attribution — denials by front-end fix categoryMission 19 →
QUALIFY1 mission
Banking·HardQuarter-end balance snapshot (Y-9C style)Mission 20 →
Quartile bucketing1 mission
Pharma Commercial·HardCopay distribution per product — NTILE(4) quartilesMission 13 →
RANK PARTITION BY department1 mission
Hospital RCM·MasterProvider effectiveness — charges vs collections delta, ranked within departmentMission 22 →
RANK PARTITION BY manager1 mission
Pharma Commercial·MasterRep effectiveness — calls vs Rx delta paired pivot, ranked within districtMission 22 →
RANK() window1 mission
Clinical Ops·HardTop 3 codes per body systemMission 11 →
Rate calc1 mission
Provider·HardProvider complication ratesMission 20 →
Rate metric1 mission
Clinical Trials·MediumSAE rate per siteMission 10 →
Recency peek1 mission
Operations·StarterShow the 5 most recent purchase ordersMission 5 →
Recent-payment filter1 mission
Consumer Lending Analyst·HardRefi candidate cohortMission 18 →
Refund filtering1 mission
Marketing·MediumWhich campaign drove the most revenue?Mission 11 →
Refunds1 mission
Marketing·StarterWhat are people buying?Mission 5 →
Retention logic1 mission
Finance·ExpertVendor onboarding cohortsMission 23 →
Revenue projection1 mission
Payer Claims·MasterRecoverable revenue at historical overturn rateMission 22 →
Risk labeling1 mission
Operations·MasterSupplier concentration risk per category (Herfindahl index)Mission 29 →
Rolling window1 mission
Retail Banking Operations·MediumPrimary banking relationship classificationMission 8 →
ROWS BETWEEN1 mission
Provider·ExpertPatient satisfaction trend with moving averageMission 22 →
Running total1 mission
Finance·MasterCash burn waterfall — monthly net + cumulative runwayMission 27 →
Same-SKU different-warehouse1 mission
Operations·MasterMulti-warehouse rebalancing planMission 27 →
Same-store filter1 mission
BI·MasterSame-rep regional growth — apples-to-apples YoYMission 30 →
Scalar subquery1 mission
Clinical Ops·MediumBody system distributionMission 8 →
SCD21 mission
Operations·ExpertPoint-in-time supplier on-time target (SCD2 reconstruction)Mission 21 →
SCD2 first-amount1 mission
RevOps·MasterDiscount slippage by close-quarterMission 26 →
SCD2 reopen detection1 mission
RevOps·MasterClawback exposure on reopened dealsMission 34 →
Segment impact1 mission
Retail Banking Operations·MasterNSF/OD fee cap scenario by FICO bandMission 28 →
Self-join fact_diagnoses1 mission
Clinical Ops·ExpertComorbidity co-occurrence matrixMission 16 →
Self-join on dim1 mission
Operations·MasterMulti-warehouse rebalancing planMission 27 →
Self-join via dual CTEs1 mission
Clinical Ops·HardCoding shift detectionMission 15 →
Self-join with rn directionality1 mission
Clinical Trials·MasterAdverse-event temporal cluster detectionMission 23 →
Sensitivity1 mission
Consumer Lending Analyst·MasterRate-shock stress test on ARM payments (+200bp)Mission 28 →
Share %1 mission
Finance·MasterVendor concentration drift YoYMission 28 →
Shopify+Stripe+GA41 mission
E-commerce·ExpertThree-system revenue reconciliationMission 22 →
Signal count1 mission
AML & Fraud·MasterMulti-signal customer risk scoreMission 26 →
Signed vs ABS error1 mission
Operations·ExpertForecast accuracy decomposition (bias + precision per SKU)Mission 24 →
Single-row exec dashboard1 mission
Retail Banking Operations·MasterRetail Ops capstone scorecardMission 30 →
Single-table aggregation1 mission
Clinical Ops·EasyEncounter diagnosis volume by typeMission 4 →
Slippage1 mission
RevOps·MasterDiscount slippage by close-quarterMission 26 →
Snapshot fact1 mission
Retail Banking Operations·MediumAverage daily balance for fee waiversMission 13 →
SOUNDEX / LEVENSHTEIN1 mission
AML & Fraud·HardSOUNDEX-style name dedup across customer_idsMission 17 →
Spine + LEFT JOIN1 mission
Finance·MasterLate-posting impact on monthly totalsMission 29 →
SQRT(AVG(x²) − AVG(x)²)1 mission
Operations·MasterDemand stability per SKU (coefficient of variation)Mission 28 →
Status filter1 mission
Consumer Lending Analyst·Easy30+ delinquent loan countMission 9 →
Status pivot1 mission
Consumer Lending Analyst·HardDelinquency progression: first miss × current statusMission 19 →
Status transition1 mission
Hospital RCM·ExpertAppeal overturn cohort — denied claims that paid after appealMission 17 →
String construction1 mission
Consumer Lending Analyst·ExpertHMDA LAR row reconstructionMission 23 →
Stripe fee allocation1 mission
E-commerce·MasterFX-adjusted net revenue per channelMission 29 →
Structuring hint1 mission
AML & Fraud·EasySub-$10K cash deposits by customerMission 6 →
Submit → deny → appeal → overturn1 mission
Payer Claims·MasterEnd-to-end claim lifecycle funnelMission 21 →
Subquery1 mission
Provider·HardDepartment utilization ratesMission 19 →
Subquery IN1 mission
Clinical Ops·MasterThe comorbidity profile — what travels with heart failureMission 22 →
Subset comparison1 mission
Consumer Lending Analyst·HardApproval gap by LMI tractMission 20 →
substr month rollup1 mission
Clinical Trials·HardRunning enrollment by monthMission 12 →
SUM OVER PARTITION1 mission
Operations·MasterSupplier concentration risk per category (Herfindahl index)Mission 29 →
SUM(CASE WHEN NULL)1 mission
Clinical Ops·HardPOA documentation rate by codeMission 12 →
SUM(CASE) pivot1 mission
Clinical Trials·ExpertAE attribution matrix — intervention × severityMission 16 →
SUM(flag) / COUNT(*)1 mission
Clinical Trials·MediumAdherence rate per enrollmentMission 7 →
SUM(share*share) HHI1 mission
Clinical Ops·ExpertDepartment CCSR concentration (HHI)Mission 18 →
Survival fraction1 mission
Clinical Trials·MasterPatient retention curve — Kaplan-Meier-style step functionMission 24 →
Tenure bucketing1 mission
BI·MasterTenure-adjusted attainment scorecardMission 28 →
Terminology join1 mission
Clinical Ops·MasterTranslate the codes — top principal diagnosesMission 21 →
Territory attribution chain1 mission
Pharma Commercial·MasterRep effectiveness — calls vs Rx delta paired pivot, ranked within districtMission 22 →
Three-CTE pipeline1 mission
Consumer Lending Analyst·ExpertCumulative loss curve by vintage × months-to-charge-offMission 25 →
Threshold1 mission
Operations·ExpertReorder-point breach: SKUs below their ROPMission 25 →
Threshold compare1 mission
Consumer Lending Analyst·MediumPricing exception detector (rate vs benchmark)Mission 14 →
Thresholds1 mission
Banking·MediumStructuring flag — sub-$10K cash depositsMission 14 →
Tiebreakers1 mission
Clinical Ops·HardEncounter complexity score — top 10Mission 14 →
Tiered CASE1 mission
RevOps·MasterComp accelerator math (2025-Q1)Mission 33 →
TO_CHAR1 mission
Operations·ExpertLead-time trend per supplier (monthly average)Mission 22 →
Top-N CTEs1 mission
Clinical Ops·ExpertComorbidity co-occurrence matrixMission 16 →
Tracking gap1 mission
E-commerce·HardGA4 conversion-value vs Shopify revenueMission 19 →
Trade-off visibility1 mission
Clinical Trials·MasterSponsor performance benchmark — multi-metric ranksMission 25 →
Trailing-space gotcha1 mission
Consumer Lending Analyst·EasyOriginations by LO (top 10)Mission 10 →
True positives1 mission
AML & Fraud·HardAlert precision — how good is our rule?Mission 18 →
Two-axis comparison1 mission
Finance·MasterLate-posting impact on monthly totalsMission 29 →
Two-CTE pattern1 mission
Clinical Trials·MediumSAE rate per siteMission 10 →
Two-fact reconciliation1 mission
Hospital RCM·MasterProvider effectiveness — charges vs collections delta, ranked within departmentMission 22 →
Two-stage funnel1 mission
Marketing·MasterSend fatigue — engagement decay by send rankMission 29 →
Two-step grain1 mission
Operations·MasterDemand stability per SKU (coefficient of variation)Mission 28 →
Type-uniform value column1 mission
Operations·MasterOperations KPI capstone (board scoreboard)Mission 30 →
UNION1 mission
AML & Fraud·ExpertCTR / SAR filing candidate listMission 22 →
UNION ALL composition1 mission
AML & Fraud·MasterMulti-signal customer risk scoreMission 26 →
Variance %1 mission
Finance·HardBudget-attainment heat mapMission 20 →
Variance calculation1 mission
Hospital RCM·HardUnderpayment detection — contracted vs paidMission 14 →
Vintage curve1 mission
Banking·MasterVintage delinquency drift YoY (12-MOB)Mission 27 →
Visit-log proxy for last seen1 mission
Clinical Trials·MasterPatient retention curve — Kaplan-Meier-style step functionMission 24 →
Volume effect1 mission
BI·MasterYoY revenue decomposition — price vs volumeMission 27 →
Watchlist1 mission
RevOps·MasterClawback exposure on reopened dealsMission 34 →
Waterfall1 mission
RevOps·ExpertARR bridge — starting + new + expand per quarterMission 22 →
Week-over-week1 mission
Retail Banking Operations·EasyBranch 13 missing transactionsMission 6 →
Weighted by ADB1 mission
Retail Banking Operations·MediumDeposit beta on MMAs (cycle-to-date)Mission 11 →
WHERE category1 mission
Clinical Ops·EasyBrowse the cardiology codebookMission 1 →
WHERE IS NULL1 mission
Provider·EasyWho's currently admitted?Mission 6 →
WHERE vs HAVING1 mission
Clinical Ops·HardEncounters carrying multiple HCCsMission 13 →
Window AVG over PARTITION1 mission
Payer Claims·HardProvider denial-rate outliers (specialty-adjusted)Mission 11 →
Window function bucketing1 mission
Marketing·MasterSend fatigue — engagement decay by send rankMission 29 →
Window over GROUP BY1 mission
Clinical Trials·MediumArm balance — flag the imbalanced trialsMission 6 →
Window share-of-total1 mission
Consumer Lending Analyst·MediumDTI bucket pivot for originationsMission 13 →
Window SUM1 mission
Consumer Lending Analyst·ExpertCumulative loss curve by vintage × months-to-charge-offMission 25 →
Window SUM as running total1 mission
Clinical Trials·HardRunning enrollment by monthMission 12 →
Window SUM frame1 mission
Payer Claims·HardRolling 90-day denial trendMission 13 →
Within-window EXISTS1 mission
Retail Banking Operations·HardOnboarding funnel: 90-day primary-relationship rateMission 15 →
Year pivot1 mission
Finance·MasterVendor concentration drift YoYMission 28 →
YoY delta1 mission
Banking·MasterVintage delinquency drift YoY (12-MOB)Mission 27 →
Z-score-style deviation1 mission
Payer Claims·HardProvider denial-rate outliers (specialty-adjusted)Mission 11 →
Zero-activity guard1 mission
Pharma Commercial·MediumRep call activity vs target — surface zero-call repsMission 10 →