Aggregation Interview Questions

16 real Aggregation questions asked in live technical interviews — each with a model answer. Updated weekly.

🎤 Auto-captured by Assisting AI during live interviews

These Aggregation interview questions were captured from real interviews by candidates using Assisting AI. Each links to a full model answer. For real-time help during your own interview, get Assisting AI from ₹500/day.

What does this SQL query do?🟢 Easy · Conceptual · Asked 2×What is the difference between COUNT(*) and COUNT(email) in SQL?🟢 Easy · Conceptual · Asked 1×Why should the GROUP BY clause include the distance column instead of destination in this query?🟡 Medium · Conceptual · Asked 1×How would you process 100GB of data in a distributed computing environment? How would you split it into chunks and aggregate the results?🔴 Hard · Conceptual · Asked 1×Explain the recursive CTE query that calculates total salary per employee hierarchy, line by line.🟡 Medium · Conceptual · Asked 1×Explain the workflow of the recursive CTE query that calculates total salary per employee hierarchy.🟡 Medium · Conceptual · Asked 1×Explain Q3, the recursive CTE that walks the org hierarchy and sums salaries.🟡 Medium · Conceptual · Asked 1×How can you find customers who have data for all 12 months in a year using SQL?🟡 Medium · Conceptual · Asked 1×How would you compute a 7‑day rolling average of daily revenue when there can be multiple transactions per day, using transaction timestamps?🟡 Medium · Coding · Asked 1×Write a SQL query to retrieve the top 3 customers by total purchase amount in the last 6 months.🟡 Medium · Conceptual · Asked 1×What is the error in the following SQL query that finds employees working on projects greater than or equal to the average number of projects per employee?🟢 Easy · Debugging · Asked 1×What is a better approach to find employees working on projects greater than or equal to the average number of projects per employee?🟡 Medium · Conceptual · Asked 1×Write a SQL query that returns the first and last purchase dates for each customer-product pair, only including pairs with at least two completed orders.🟡 Medium · Coding · Asked 1×Explain the following SQL query: SELECT customer_name, COUNT(*) FROM customerTable WHERE CITY_Name LIKE '%Pu%'?🟢 Easy · Conceptual · Asked 1×Give PySpark code to calculate the friend acceptance rate for each date when friend requests were sent. A request is sent if action = 'sent' and accepted if action = 'accepted'. If a request is not accepted, there is no record of it being accepted in the table. The output should only include dates where requests were sent and at least one of them was accepted (acceptance can occur on any date after the request is sent).🟡 Medium · Coding · Asked 1×How would you transform the bronze_user_sessions table into a silver table with aggregated session metrics?🟡 Medium · Conceptual · Asked 1×

🎤 Get Aggregation questions answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500

Browse Other Topics