Top 50 Aggregations Interview Questions
The most frequently asked Aggregations questions across all roles and companies, ranked by real interview frequency. Updated daily.
Use GROUP BY and SUM to rank the top 10 customers by total revenue from a single sales table.
Housecall Pro
Equifax
XYZFind the top 10 products by total sales revenue using joins, aggregation, and a CTE.
RTX
iSmile Technologies
CatalinaAggregate customer sales volume and return Pyramid Consulting's top 10 customers in descending order.
Pyramid Consulting
BNY
Cambia Health SolutionsFind duplicate customer profiles by grouping on identifying fields and returning only repeated records.
Adtalem Global Education
University of Southern California
Blue Cross Blue Shield of MichiganSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Extract qualifying market observations by venue and price, then return them in chronological order.
Equifax
DPR Construction
MITRECalculate month-over-month sales growth for each product category using JOINs and window functions.
Wayfair
REVOLVE
FanaticsUse CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.
Curefit
Indeed
TikTokOptimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
Capgemini
Nomura