SQL Aggregation Practice Problems: 563 Questions with Solutions
563 SQL aggregation practice problems with solutions: GROUP BY, HAVING, COUNT, SUM, AVG and COUNT DISTINCT. Written in MySQL, judged on hidden datasets.
- Problems: 563
- By difficulty: 134 easy · 291 medium · 138 hard
- Dialect: MySQL
Practise SQL aggregation: GROUP BY with COUNT, SUM, AVG, MIN and MAX, HAVING to filter groups, COUNT(DISTINCT …) and grouping after a join. Every reference solution is written in MySQL and checked against a real MySQL 8. Aggregation is where most reporting questions — totals per day, the top customer, averages per department — begin.
Easy SQL aggregation problems
- Mobile Numbers Shared by Wallet Accounts
- Clubs With Enough Members to Register
- Rating Report for Each Canteen Counter
- Average Selling Price of Each Canteen Item
- Faculty Pay Against the Department Average
- Active Deposits Held at Each Branch
- Customers Holding Both Savings and Current Accounts
- Civic Grievances Filed per Department
- NGO Donors Grouped by Email Domain
- Box Office Revenue per Show
- Seller GMV From Delivered Items
- Coupon Redemption Summary per Code
- Marketplace Orders per Month in 2024
- Average Quiz Score for Quizzes With Three or More Attempts
- Learner Sign-ups by E-mail Domain
- Delivered GMV of Every Dark Store
- Restaurants Averaging Under 3.5 Stars
- In-Game Store Revenue by Item Category
- Average Completed Match Length by Game Mode
- Daily Active Players From the Login Log
- Players Rated Above the Average MMR
- Completed OPD Visits per Department in March 2025
- Average Consultation Fee by Specialty
- On-Payroll Headcount by Department and Work Mode
- Late Punch-Ins per Employee in March 2025
- Referral Bonus Owed to Each Employee
- Machine Count per Plant From Asset Tags
- EV Charging Energy Delivered per Station
- Solar Plant Monthly Generation in 2024
- Completed Work Orders and Good Units per Line
- Click-Through Rate of Every Ad Group
- Email Campaigns That Drove Two or More Unsubscribes
- Paid Media Spend per Channel in March 2024
- Shipments Booked at Each Courier Hub
- Active Fleet Vehicles by Registration State
- Ride Request Outcome Mix: Rider, Driver or No Driver
- Open Ticket Load per Support Agent
- Hosts That Hit CPU Saturation
- Deployment Outcomes per Service
- Error Codes in the API Gateway Logs
- Rate per Square Foot by Locality
- Society Maintenance Dues Collected per Wing
- Stores Crossing ₹20,000 in Paid POS Bills
- Category Codes From SKU Prefixes
- Net Stock Change per SKU From the Movement Log
- March POS Bills by Day of the Week
- Warehouse Stock Value Including Empty Sites
- Daily Active Users From the Event Log
- Signups by Work Email Domain
- Feature Adoption, Including Features Nobody Used
- Stories Posted and Total Story Views per User
- Hashtags Used on Three or More Live Posts
- Economical Bowlers of the T20 Season
- Season Attendance at Each Football Stadium
- Batters Who Were Out for a Duck This Season
- Watch Hours by Genre
- Accounts With Two or More Kids Profiles
- August Data Usage by Telecom Circle
- Completed Port-Outs by Recipient Operator
- Room Nights Sold per Hotel
- Hotel Loyalty Members per Email Domain
- Loyalty Tier Headcount From Points Balance
- Airbnb: Average Cleaning Fee by Property Type
- Airbnb: Experience Bookings and Guests per Category
- Airbnb: Friday and Saturday Check-Ins per City
- Amazon: Search Queries Mentioning Each Brand
- Amazon: Associates Meeting the 100 Units-per-Hour Pick Target
- Amazon: Alexa Requests and Households by Device Family
- Amazon: Subscribe & Save Discount Tier per Delivery Month
- Amazon: EC2 Billable Seconds With the One-Minute Minimum
- Apple: Genius Bar No-Shows at Every Store
- Apple: Trade-In Credit Paid by Device Family
- Apple: App Store Apps Not Updated Since Mid-2023
- Apple: Apple Music Family Plans With Spare Seats
- Apple: Online Orders With Both an iPhone and AirPods
- Dream11: Gross Winnings, Tax Withheld and Net Payout per User
- Dream11: Saved Teams Over the 100-Credit Cap
- Dream11: Promo Code Redemptions per Campaign
- Dream11: Contests and Prize Pools per Sport in May 2025
- Dream11: Deposits Above a User's Own Monthly Limit
- Flipkart: Active F-Assured Listings per Seller
- Flipkart: Orders Placed Each Day of Big Billion Days
- Flipkart: Pay Later Accounts Spending Past Their Limit
- Google: Zero-Result Searches per Locale
- Google: Accounts Over Their Storage Quota
- Google: Well-Rated Places With Enough Reviews
- Google: March Cloud Bill for Every Project
- Google: Pixel Units Sold and Returned per Model
- Hotstar: Commentary Languages Live on Each Match
- Hotstar: Buffering Share of Watch Time by CDN
- Hotstar: Next-Day Views of Regional Serials
- Hotstar: Matches That Crossed Two Crore Concurrent Viewers
- Hotstar: Playback Errors by App Platform
- LinkedIn: Active Premium Members per Plan on Quarter End
- LinkedIn: Skills Endorsed by Three or More Different People
- LinkedIn: InMail Response Rate per Recruiter
- LinkedIn: Learning Course Completions per Category in Q1 2025
- LinkedIn: Easy Apply Share of Applications per Job
- Meta: Going and Interested Counts per Facebook Event
- Meta: Ad Accounts That Overspent Their September Limit
- Meta: Messenger Video Call Minutes by Day of the Week
- Meta: Quest Store Apps Rated by at Least Three Players
- Microsoft: Gamerscore Awarded per Xbox Title
- Microsoft: Azure Resource Count per Resource Group From Resource IDs
- Microsoft: Products With Three or More Severity A Cases in March
- Myntra: Most Common Return Reasons in 2024
- Myntra: M-Now Deliveries Inside the 30-Minute Promise by Store
- Ola: Completed Rentals Bookings per Hourly Package
- Ola: Wallets Topped Up Over ₹10,000 in May 2024
- Ola: Test Ride Bookings and No-Shows per Experience Centre
- Paytm: Wallet Users by KYC Level in Each City
- Paytm: February LPG Cylinder Bookings by Gas Provider
- Paytm: January FASTag Toll Spend for Each Vehicle
- Paytm: Digital Gold Customers Holding at Least One Gram
- PhonePe: Users With Three or More Active Linked Bank Accounts
- PhonePe: In-App Insurance Premium by Product Line in 2025
- PhonePe: Delivered Pincode Orders per Partner Store, Zeros Included
- Razorpay: Captured Volume by Payment Method per Merchant
- Razorpay: Merchants Whose KYC Documents Are All Unverified
- Razorpay: Magic Checkout Conversion Rate by Merchant
- Spotify: Skips and Full Plays per Track
- Spotify: Family and Duo Plans With Open Seats
- Spotify: Artist Merch Revenue From Shipped Orders
- Swiggy: Rain Fee Collected per City
- Swiggy: Dineout Restaurants With Repeat No-Shows
- Uber: Airport Queue Dispatches per Terminal
- Uber: Riders Who Gave Every Rated Trip Five Stars
- Uber: Cities With Two or More Critical Safety Reports
- Walmart: Active Walmart+ Members on 30 June by Plan
- Walmart: Grocery vs General Merchandise Sales per Store
- Walmart: Supercenters per State From Store Codes
- Zomato: Veg, Non-Veg and Egg Dishes on Every Menu
- Zomato: Feeding India Cities That Raised ₹50,000
- Zomato: Sold-Out Movie Shows on District
Medium SQL aggregation problems
- Delivery Captains Leading Five or More Riders
- OTP Verification Rate of Every Account
- Mock Test Sittings for Every Learner and Track
- Share of Quiz Players Who Returned the Next Day
- Students Who Attended Every Fest Workshop
- Monthly Ticket Refund Report by Railway Zone
- Second-Best Innings in the College Cup
- Student With the Most Study Buddies
- Crop Cover for Shared Amounts on Unique Plots
- Top Reviewer and Best-Rated Dish of February
- Gym Members' First and Latest Branch
- Cloud Kitchen Seven-Day Moving Average
- UPI Success Rate by App and Month
- Current Balance From the Account Ledger
- Borrowers With Repeatedly Overdue EMIs
- Credit Cards Over 30% Utilisation in September
- Salary Credits by Employer From Statement Narrations
- Loan Book Asset Classification by Branch
- Library Members Blocked for Unpaid Fines
- Grievances Resolved Within the Seven-Day SLA
- Constituency Winners From Booth-Level Counts
- Recurring Donors Across Three Months of 2024
- Concert Sell-Through and Sales Status
- Books With the Longest Reservation Queue
- Grievance Tickets per Ward From Reference Codes
- Cart Abandonment Rate by Device
- Sellers With a High Return Rate
- Best-Rated Product in Each Category
- Delivery SLA Breaches by Postal Zone
- Monthly GMV Against the Previous Calendar Month
- Monthly Fee Collection by Payment Mode
- Courses Where More Than a Quarter of Students Failed
- Course Completion Percentage for Each Learner
- Placement Rate and Top Package by Branch
- Late Coursework Uploads and Average Hours Late per Course
- Course Catalogue Summary by Department and Level
- Riders Missing the Delivery SLA in June 2024
- Peak-Hour Share of Orders by City
- Best-Selling Dish of Each Restaurant
- Orders Above the Customer's Own Average Basket
- Rider Login Hours and July Incentive Tier
- Month-Over-Month Delivered GMV Change by City
- Packing Slip Item List for Each Quick Order
- Coupon Discount Spend by Campaign Prefix
- Player Win Rates With at Least Five Matches
- Top In-App Spender in Each Region for 2025
- Ranked Queue Wait Time by Hour of Day
- Players Reported for Cheating by Three Reporters in a Month
- Whale Share of Monthly Store Revenue
- Guilds With Three Active Members in the Last Week
- Email Domains Behind Unverified Sign-ups
- OPD No-Show Rate by Doctor
- Most Prescribed Drug in Each Department
- Cashless Claims Settled per Insurer per Month
- Patients Seen Across Several Specialties
- Ward Bed Occupancy on the Census Date
- Medicines Below Their Reorder Level
- Employees Averaging Less Than Eight Hours a Day
- Appraisal Rating Mix by Department
- Average Days to Fill a Requisition by Department
- Staffing Pool of Multi-Skill Experts
- Machines With Over Two Hours of Unplanned Downtime
- Sensor Threshold Breach Rate
- Top Operators per Shift by Good Output
- Late Work Order Rate by Line
- Batches Worse Than Their Product's Defect Rate
- Incoming Lot Rejection Rate by Supplier
- Machines With Repeating Fault Codes
- Sign-ups by UTM Source Read From Landing URLs
- Cost per Acquisition of Every Campaign
- Campaign Months That Overspent the Budget
- Email Open Rate by Hour of Send
- Campaigns Outspending Their Channel's Average
- Weekly Leads by UTM Medium
- Email Subscribers Who Open but Never Click
- Dispatch Offer Acceptance Rate per Driver
- Couriers Who Missed the Delivery SLA on Over 20% of May Drops
- Drivers Qualifying for City Trip Incentives
- Monthly Completed Trips, GMV and Average Fare
- Fleet Utilisation by Vehicle Type for One Week
- Promo Campaign Redemptions and Discount Burn
- Couriers Delivering More Than Their Hub's Average in June
- First-Response SLA Breach Rate by Priority
- Support Agents With a High Ticket Reopen Rate
- Slowest Endpoint in Each Service
- Monthly Change Failure Rate of Production Deploys
- Agents Carrying More Than Their Team's Average Workload
- Services Missing Their Uptime Target
- Error Counts by Region and Environment From Hostnames
- Agent CSAT Rank Within Each Support Team
- Broker Site-Visit Conversion Rate
- Monthly Rent Collection: On Time, Late and Unpaid
- Flats Owing More Than Their Wing's Average
- Parse Listing Titles Into Locality and BHK
- Days From First Site Visit to Booking
- Each Broker's Best Month by Deal Value
- Towers Where Every Unit Cleared March Dues
- Supplier Average Lead Time in Days
- Purchase Order Lines Received Short
- Store Stock-Out Rate From Daily Closing Stock
- Top-Selling SKU in Each Store, Ties Included
- Cycle Count Shrinkage Value by Store and Month
- Duplicate Vendors After Cleaning Up Their Names
- Stores Beating Their City's Average in Q1
- Days From Signup to First Captured Payment
- Pricing Page A/B Test Conversion by Variant
- Top Two Features in Every Pricing Plan
- Power Users Active on Four or More Days a Month
- Signups and Upgrades by UTM Source
- Monthly Active Users, New Versus Returning
- Seat-Based Monthly Bill for Every Workspace
- Creator Engagement Rate by Month
- Moderation Outcomes by Report Reason
- Drive-By Commenters Who Never Liked the Post
- Sign-Ups by Email Provider
- Most Common Leading Hashtags in Captions
- Creators Whose Latest Post Underperformed
- Group Chats Silent for More Than 30 Days
- Football League Table With Points and Goal Difference
- Death-Overs Economy From Ball-by-Ball Data
- Fantasy Gameweek Scores With the Captain's Double Points
- Wickets Credited to Each Bowler From the Dismissal Text
- Monthly Active Viewers and Minutes per Viewer
- Completion Rate of Every Series
- Most-Streamed Artist in Every Genre
- Artist Royalties for May 2024
- Listeners With a Song on Repeat
- Titles Licensed in Every Region on Launch Day
- Playlist Length as Clock Time
- Sign-Up Channels by First-Week Activation
- Most Recharged Prepaid Plan in Each Circle
- Data Users Above Their Circle's Average
- Monthly Recharge Revenue by Pack Type
- Consumers With Repeated Late Payment Fees
- International Voice Call Share per Caller
- Hotel Occupancy on New Year's Eve
- Average Daily Rate by Hotel and Month
- On-Time Arrival Performance by Airline
- Top Two Agencies by Commission Each Quarter
- Hotel Cancellation Refunds Under a Tiered Policy
- Connecting Itineraries per City Pair
- Airbnb: Hosts Meeting a Simplified Superhost Bar
- Airbnb: Host Response Rate Within 24 Hours
- Airbnb: Search-to-Booking Funnel by Platform
- Airbnb: Most-Wishlisted Listing in Each City
- Airbnb: Rank Experiences by a Bayesian Average Rating
- Airbnb: Guest Cancellation Rate by Cancellation Policy
- Airbnb: Hosts Whose Every Active Listing Is Instant Book
- Amazon: Star Rating Breakdown for Each Product
- Amazon: Warehouse Bins Shared by Several Sellers
- Amazon: Savings Plan Coverage of Each AWS Account
- Amazon: Route Stops Delivered Out of the Planned Order
- Amazon: Referral and FBA Fees per Seller for October
- Amazon: Straight-Line Distance Driven on Each Delivery Route
- Apple: Daily Share of Checked-In Devices on iOS 18
- Apple: Category Leaders by Q4 Net App Revenue
- Apple: Developer Proceeds After Commission in March 2025
- Apple: Apple Pay Monthly Volume Change by Country
- Apple: Component Batches Below Their Pooled Test Yield
- Apple: Each Product Line's Share of Store Revenue
- Apple: Running iCloud+ Subscriber Count by Day
- Apple: New and Cumulative Unique Apple Arcade Players by Day
- Dream11: Selection Percentage of Every Player per Match
- Dream11: Most-Picked Captain in Every Match
- Dream11: Saved Teams Carrying Players Left Out of the XI
- Dream11: Contest Entries by Format for Each Match
- Dream11: Private Leagues Cancelled Below Their Minimum Size
- Dream11: Withdrawal Requests Made Before KYC Approval
- Dream11: Each Player's Form Over Their Last Three Matches
- Dream11: Multiple Accounts Behind One Gmail Address
- Flipkart: Refund SLA Breaches by Product Category
- Flipkart: Months Members Burned More SuperCoins Than Earned
- Flipkart: Pincodes Where COD Parcels Keep Coming Back
- Flipkart: Products Rated Lower After Big Billion Days
- Flipkart: Certified Buyer Reviews and Their Rating per Product
- Flipkart: F-Assured Sellers Missing the 24-Hour Dispatch SLA
- Flipkart: Sale Shoppers Who Bought From Three Categories
- Flipkart: Top Three Brands per Category Plus an Others Line
- Flipkart: Pay Later Bills Not Cleared by the Due Date
- Flipkart: Running GMV Through the Sale by Category
- Google: Click-Through Rate at Every Organic Position
- Google: Drive Files Shared Outside the Owner's Domain
- Google: Places per Top-Level Maps Category
- Google: Gmail Spam Filter Precision and Recall per Model
- Google: Meet Calls Where Guests Waited for a Late Host
- Hotstar: Advertisers Owed Make-Good Impressions
- Hotstar: Commentary Language Split per Match
- Hotstar: Subscribers Who Only Ever Watch Live Sport
- Hotstar: Worst Rebuffering CDN and Device in Each City
- Hotstar: Accounts Streaming From Three Cities in a Day
- Hotstar: Unsold Ad Slots by Innings Phase
- Hotstar: Top Two Shows per Language by Unique Viewers
- Hotstar: Final-Day Paid Sign-Ups by Hour With a Running Total
- LinkedIn: Connection Count of Every Member
- LinkedIn: Invitation Acceptance With and Without a Note
- LinkedIn: Members Whose Profile Views Doubled in May
- LinkedIn: Most Common Reaction on Each Post
- LinkedIn: Premium Free-Trial Conversion by Trial Month
- LinkedIn: Running Follower Count of Company Pages
- LinkedIn: Members With Exactly the Same Skill Set
- Meta: Ad Set Metrics Unpivoted Into Long Format
- Meta: WhatsApp Business Message Delivery Funnel
- Meta: Advertisers Whose Spend Fell Three Months Running
- Meta: Moderators Overturned More Often Than Their Team
- Meta: Instagram Follow-Backs Within a Week
- Meta: Messenger Call Drops by Major App Version
- Meta: Running Quest Store Revenue per Developer
- Meta: Marketplace Listings Against the Same Month Last Year
- Microsoft: Azure Q1 Cost Split by Service Family per Month
- Microsoft: Teams Channels Where Guests Post Most Messages
- Microsoft: Xbox Players Who Unlocked Every Achievement in a Title
- Microsoft: Paid but Unassigned Microsoft 365 Seats on 30 June
- Microsoft: Bing Query Abandonment Rate by Market
- Microsoft: Top Human Contributor per GitHub Repository in 2025
- Microsoft: Customers Billed for Both Azure and Microsoft 365
- Microsoft: Teams Daily Stickiness (DAU/MAU) in March 2025
- Microsoft: Privileged Azure Role Holders for the Access Review
- Myntra: Size-Related Return Rate by Article Type and Size
- Myntra: Creator Store Commission for October 2024
- Myntra: Wishlist-to-Purchase Conversion by Article Type
- Myntra: Delivered GMV by Indian Fiscal Year and Quarter
- Myntra: Size Exchanges Blocked by an Unavailable Size, per Brand
- Myntra: Monthly Net Revenue After Refunds in 2024
- Myntra: Styles Most Shoppers Say Run Small
- Ola: Scooters With Outlier Energy Use Within Their Model
- Ola: Busiest Hour of the Day at Each Hypercharger
- Ola: Test Riders Who Bought Within 30 Days, per Centre
- Ola: Wallet Cashback That Was Not Fully Credited
- Ola: Driver-Partners Cleared on All Four Documents
- Ola: Riders Whose Main Ride Moved From Auto to Cabs
- Ola: Auto, Mini and Prime Ride Mix in Each City
- Paytm: Runner-Up Movie by Seats Sold in Each City
- Paytm: Users Who Paid Electricity in Every Month of Q1 2025
- Paytm: Days Loan Deductions Took Over Half a Merchant's Settlement
- Paytm: Scratch Cards That Expired Unscratched
- Paytm: Busiest Day for Each EDC Card Machine
- Paytm: Cashback Paid Above the Per-User Campaign Cap
- Paytm: Merchant Days When QR Collections Fell by More Than Half
- PhonePe: Most Frequent UPI Decline Code at Each Remitter Bank
- PhonePe: Monthly P2P Versus P2M Payment Value in 2024
- PhonePe: Top District by Transaction Count in Each State, Q2 2025
- PhonePe: Open Share.Market Positions From the Order Book
- PhonePe: Motor Policy Renewal Rate by Expiry Month
- PhonePe: Collect-Request Senders Declined More Often Than Not
- PhonePe: New Users Who Tried Three Products in Their First 30 Days
- Razorpay: Card Payment Success Rate by Issuing Bank
- Razorpay: Chargeback Rate by Merchant Category
- Razorpay: Webhook Events That Never Got a 2xx Response
- Razorpay: Subscription Cycles Recovered by Retry vs Halted
- Razorpay: Leading Card Network in Each Merchant Category
- Razorpay: UPI Ticket Sizes in ₹1,000 Bands, Empty Bands Included
- Razorpay: Settlements That Don't Match Their Line Items
- Spotify: Discover Weekly Save Rate per Listener
- Spotify: Free Listeners Who Hit the Hourly Skip Cap
- Spotify: Wrapped Top Artist of Every Listener
- Spotify: Collaborative Playlists Only the Owner Edits
- Spotify: Ad Load by Market Against the Four-an-Hour Cap
- Spotify: Shared Plans With Members at Different Addresses
- Spotify: Songwriter Splits That Don't Add Up to 100%
- Spotify: Listeners Who Played an Album Front to Back
- Spotify: Featured-Artist Credits in Track Titles per Label
- Swiggy: Share of Each Partner's Orders Delivered in a Batch
- Swiggy: Instamart SKUs Out of Stock Across a Whole City
- Swiggy: Swiggy One Plans That Paid for Themselves
- Swiggy: Orders That Stacked Two Platform Coupons
- Swiggy: Food Customers Who Later Tried Instamart
- Swiggy: Genie Tasks Flagged by Blocked Keywords
- Swiggy: Busiest Instamart Store per City Each Month
- Swiggy: Partner Top-Up to the Shift Earnings Guarantee
- Uber: Surge Share of Bengaluru Trips by Hour of Day
- Uber: Pickup ETA Accuracy by City
- Uber: Drivers Gone Quiet Before the Festive Rush
- Uber: Promo Abuse — One Device, Many Accounts, Same Campaign
- Uber: Uber Pro Leaderboard Around Driver 107 in Pune
- Uber: UberX Share Requests Matched With a Co-Rider
- Walmart: Price Match Approval Rate by Competitor
- Walmart: Clearance Items Marked Down Three Times With No Sale
- Walmart: Substitutions Made Against the Customer's Wishes
- Walmart: Pickup Slot Fill Rate by Hour of Day
- Walmart: Each Store's Sales Gap to Its Region's Leader
- Walmart: Repeat Receiptless Returns Across Stores
- Walmart: Item Records Sharing a UPC After Cleanup
- Walmart: Late Store Deliveries by Day of the Week
- Zomato: Gold Membership Renewal Rate by Plan
- Zomato: Cost per Order of Each Promoted Listing
- Zomato: Best-Rated Dining Spot in Each Locality
- Zomato: District Event Sell-Through by Category
- Zomato: Restaurants Buying From Hyperpure Every Month of Q1
- Zomato: Table Reservation No-Show Rate by Meal Slot
- Zomato: Top Intercity Legends Dish in Each Destination City
- Zomato: September Photo Decisions of Every Moderator
Hard SQL aggregation problems
- Daily Cancellation Rate Without Suspended Members
- Median Delivery Time of Each Restaurant
- Savings Accounts Below the Minimum Average Balance
- Median Card Spend by Merchant Category
- UPI App New-User Retention in the Following Month
- Median Days to Close Service Requests by Department
- Donor Retention by First-Gift Year
- Monthly Buyer Cohort Retention
- Median Delivery Days per Courier Partner
- Top Three Sellers per Category in Q4, With Ties
- Next-Month Retention of Learner Sign-up Cohorts
- Median CGPA of Each Branch
- Course Funnel From Enrolment to Certificate
- Top Three Scores in Each National Mock Test
- Next-Month Retention of First-Order Cohorts
- Food App Checkout Funnel, Step by Step
- Top Two Restaurants per Cuisine by Repeat-Customer Rate
- Day-1 and Day-7 Retention by Signup Week
- Peak Concurrent Game Sessions per Server Region
- Median Completed Match Duration by Game Mode
- New-Player Funnel From Install to First Purchase by Platform
- Total Recruits Down Each Player's Referral Tree
- Median Length of Stay by Ward
- OPD New-Patient Retention by Monthly Cohort
- Insurance Claim Funnel by Insurer
- Total Team Size and Payroll Under Each Manager
- Median CTC for Each Job Level
- 90- and 180-Day Retention of 2024 Hires by Quarter
- Machine OEE per Planned Shift
- Median EV Charging Session Length by City
- First-Touch vs Last-Touch Revenue by Channel
- Median Daily Spend of Each Channel
- The Day Each Driver Hit the Monthly ₹10,000 Target
- Median Pickup-to-Drop Minutes in Each Delivery Zone
- Parcel Delivery Funnel and First-Attempt Rate by City
- 90th Percentile API Latency per Endpoint
- Repeat Contact Rate by First-Ticket Month
- Median Time to Resolve Incidents by Severity
- Median Registered Rate per Sq Ft by Locality
- Enquiry-to-Token Funnel by Lead Source
- Occupied Flats on the First of Each Month
- Top Two Agents per City by Commission, Ties Included
- Six-Month Renter Retention by Move-In Cohort
- FIFO Valuation of the Stock Left on Hand
- Median Supplier Lead Time From Goods Inward
- Products Most Often Bought in the Same Basket
- Onboarding Funnel With Steps Taken in Order
- Monthly Signup Cohort Retention
- Median Days From Trial to Paid by Acquisition Channel
- MRR Movements: New, Expansion, Contraction and Churn
- Friend Suggestions From Two or More Mutual Friends
- First-Week Retention by Sign-Up Month
- Reshare Cascades: Size, Depth and Unique Resharers
- Median Likes per Creator
- Net Run Rate of Every Team in the T20 League
- Median Fantasy Points per Gameweek by Player Role
- Fantasy App Signup Cohorts Retained Into the Next Month
- Next-Month Viewing Retention of Streaming Sign-Up Cohorts
- Median Session Length by Device
- Accounts Streaming Past Their Screen Limit
- Median Completed Call Duration per Tower
- Prepaid Recharge Next-Month Retention by Cohort
- Top Two Data Consumers per Circle, Ties Included
- Peak In-House Guests per Hotel
- Repeat-Guest Retention Within 90 Days by Cohort
- Median Departure Delay per Airport
- Nightly Rooms Sold Calendar for the Holiday Season
- Airbnb: Reconcile Host Payouts Against Earnings
- Airbnb: Quote Stays From Nightly Prices and Discounts
- Amazon: Package Dwell Time at Each Facility Visit
- Amazon: Five-Star Review Bursts From Brand-New Accounts
- Amazon: Suggested Subscribe & Save Cadence From Reorder Gaps
- Apple: Leaf Parts Needed for Each Mac Build Order
- Apple: Launch-Day Pre-Orders Filled Strictly in Queue Order
- Dream11: Contest Prizes When Tied Teams Share a Rank
- Dream11: Top Three Users by Net Winnings in Each Sport
- Dream11: Contest Winners From Player Points With C and VC Boosts
- Dream11: Second-Paid-Contest Activation Rate by Signup Month
- Flipkart: How Often Each Product's Buy Box Changed Hands
- Google: YouTube Channels Eligible for the Partner Programme
- Google: Play Service Fee and the Purchase That Crossed the Tier
- Google: Cloud VM Cost With Machine Types Filled Forward
- Google: Median First-Reply Time in Gmail Support Threads
- Google: Search Experiment Lift Without Contaminated Users
- Hotstar: 90th-Percentile Video Start Time by CDN
- Hotstar: Deduplicated Watch Minutes Across Overlapping Devices
- Hotstar: Stage Times of Slow Highlights Clips
- LinkedIn: Mutual Connections Behind Pending Invitations
- LinkedIn: Followers Across Each Company's Affiliated Pages
- LinkedIn: Applications Year over Year by Company and Quarter
- LinkedIn: First- and Second-Degree Network Size
- LinkedIn: Top Endorsed Skill per Industry and Its Lead
- Meta: Instagram Reels Shopping Funnel, Steps in Order
- Microsoft: Teams Attendees Present for at Least 75% of a Meeting
- Microsoft: Management Groups Whose Rolled-Up Azure Spend Tops Budget
- Microsoft: Xbox Hunters With the Most Rare Achievements
- Microsoft: Bing Search Sessions That Ended Without a Click
- Microsoft: Game Pass Win-Back Rate by Cancellation Month
- Myntra: Each Brand's Share of Its Category in the EORS
- Myntra: EORS First-Time Buyers Who Ordered Again Within 90 Days
- Myntra: Sizes Over-Represented in Size Returns per Article Type
- Myntra: The Few Brands Making Up 80% of Each Category's Sale Revenue
- Myntra: Serial Returners by Their Last Five Delivered Orders
- Ola: Driver-Partner Activation and Retention by Approval Month
- Ola: Scooters Covered by a Care Plan on Each Month End
- Ola: Service Tickets Breaching the 3-Working-Day SLA
- Paytm: Gold Buyers Whose Weighted Cost Beat the Simple Average
- Paytm Money: SIP Investor Retention Three Months Later by Cohort
- Paytm: Merchant Loan Outstanding as of 31 January 2025
- Paytm: Spending Before and After Cashback for Each Campaign
- PhonePe: Failed UPI Payments Recovered by a Retry, per Bank
- PhonePe: Bank Downtime Runs From Consecutive Technical Declines
- PhonePe: Merchant-Spend Quartiles of Users in Each City, March 2025
- PhonePe: Districts Whose State Rank Rose Every Quarter of 2024
- PhonePe: Merchants Earning Half Their Takings From Three Customers
- Razorpay: Merchants Whose Live Methods Differ From Their Request
- Razorpay: Diwali-Week Captured Volume Against Last Year's Diwali Week
- Razorpay: Orders Rescued by Switching Payment Method
- Razorpay: Merchants Whose Weekly Success Rate Fell 10+ Points
- Spotify: Artists Growing Year Over Year in Every Market
- Spotify: Podcast Episode-to-Episode Listener Retention
- Spotify: Pro-Rata Royalty Pool Payouts for June 2024
- Spotify: Playlist Pairs Sharing Half Their Available Tracks
- Swiggy: GMV Report With City Subtotals and a Grand Total
- Swiggy: Units Sold per Item From Instamart Combo Codes
- Swiggy: Kitchens Slowing Down Three Weeks Running
- Swiggy: Instamart Items Most Often Bought Together
- Swiggy: Instamart Picking Bags From Order Lines
- Uber: Evening Hours Where Requests Outran Online Drivers
- Uber: Freight Lane Rates Spiking Over the 28-Day Average
- Walmart: Truck Routes Rebuilt From Store Geofence Pings
- Walmart: Department Pairs Bought Together More Than by Chance
- Walmart: Understaffed Stretches on the Sales Floor
- Walmart: Assigning Pallets to Trailers Under a Weight Limit
- Zomato: Cuisine Gaps in Each Locality Worth Recruiting For
- Zomato: Most-Loved Dish of Each Restaurant and Its Complaints
- Zomato: Progressive Commission on Each Restaurant's Monthly Sales
- Zomato: Ratings Before and After a Hygiene Audit