Data Analytics Interview Write a query to find all products whose price increased in the last price update compared to the previous one. Read more ★ Save
Data Analytics Interview Write a query using EXISTS to find suppliers who have never had a late delivery. Read more ★ Save
Data Analytics Interview Write a query to find the top 5 referral sources by conversion rate from a Signups table. Read more ★ Save
Data Analytics Interview Write a query to identify the busiest hour of the day for support ticket creation using a Tickets table. Read more ★ Save
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 to find the three most recent orders for each 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 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 return the top 3 selling products per category using a subquery (no window functions allowed). Read more ★ Save