Data Analytics Interview Write a query to count how many orders each customer placed and rank customers by order count within their city. Read more ★ Save
Data Analytics Interview Write a query to find customers who bought Product A but never bought Product B. Read more ★ Save
Data Analytics Interview Write a query that returns customers whose total spend is above the 90th percentile of all customers. Read more ★ Save
Data Analytics Interview Write a query to find the three most recent orders for each customer. Read more ★ Save
Data Analytics Interview Write a query to find the first purchase date and last purchase date for every customer. Read more ★ Save
Data Analytics Interview Write a query to compute the percentage of total revenue contributed by each product category. Read more ★ Save
Data Analytics Interview Write a query to list all customers who have not placed any order in the last 90 days. Read more ★ Save
Data Analytics Interview Write a query to find employees who earn more than their direct manager, using a self-join on an Employees table. Read more ★ Save
Data Analytics Interview Write a query to find the average order value per customer segment, excluding cancelled orders. Read more ★ Save
Data Analytics Interview Write a query to calculate the running total of daily revenue for a store using a self-join. Read more ★ Save
Data Analytics Interview Write a query to return the top 3 selling products per category using a subquery (no window functions allowed). Read more ★ Save