Skip to content

Problems Questions Drills Roles Skills Interview Contest Leaderboard

Problems Questions Drills Roles Skills Interview Contest Leaderboard

Home
Data Analyst
Questions
Aggregation

Data Analyst

Aggregation questions

7 questions on Aggregation for data analysts, easiest first.

Easy 4

WHERE vs HAVINGeasy
What a pivot table doeseasy
COUNT(DISTINCT) with NULLseasy
Why this GROUP BY failseasy

Medium 1

Share of paid orders in one querymedium

Hard 2

Average of averageshard
GROUP BY with NULL citieshard

More Data Analyst skills

SQL 37 Statistics 21 Metrics 13 Excel 10 A/B Testing 10 Null Handling 8 Joins 7 Data Visualization 7 Window Functions 7 Business Math 5 Data Quality 5 Descriptive Statistics 4 Python 4 Pandas 4 Power BI 4

Aggregation across all roles →

🏆 Aggregation leaderboard →

RED SAG Skills

Free practice for every job role: coding problems, role challenges and mock interviews. Built and managed by RED SAG Fintech Solutions.

Software Engineering

Frontend Developer interview questions
Backend Developer interview questions
Full Stack Developer interview questions
Mobile App Developer interview questions
Game Developer interview questions
Blockchain Developer interview questions

Data, AI & Machine Learning

Machine Learning Engineer interview questions
AI Engineer (LLM & Generative AI) interview questions
Data Scientist interview questions
MLOps Engineer interview questions
Prompt Engineer interview questions
Data Analyst interview questions

Cloud, DevOps & Security

DevOps Engineer interview questions
Cloud Engineer interview questions
Site Reliability Engineer interview questions
Database Administrator interview questions
Cybersecurity Analyst interview questions

© 2026 RED SAG Fintech SolutionsAll roles Coding problems Leaderboard About Careers at RED SAG