Data Analytics Interview Write a SQL query to find the second highest salary from an Employees table without using LIMIT or TOP. Read more ★ Save
Data Analytics Interview Write a query to find all customers who placed orders in every month of 2025. Read more ★ Save
Data Analytics Interview Write a query to identify duplicate rows in a Transactions table based on customer_id, amount, and date. Read more ★ Save
Data Analytics Interview Write a query using GROUP BY and HAVING to find departments with more than 10 employees earning above the department average salary. 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
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 find the average order value per customer segment, excluding cancelled orders. 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 list all customers who have not placed any order in the last 90 days. 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 the first purchase date and last purchase date for every customer. Read more ★ Save
Data Analytics Interview Write a query to find the three most recent orders for each customer. Read more ★ Save