Data Analytics Interview Write a query to find all patients who missed at least two scheduled appointments in the past year. Read more ★ Save
Data Analytics Interview Write a query using a CTE to calculate a 7-day moving average of website visits. Read more ★ Save
Data Analytics Interview Write a query to return the top 10% of sales reps by revenue generated in Q1. Read more ★ Save
Data Analytics Interview Write a query to find customers who upgraded their subscription plan more than once in the last year. Read more ★ Save
Data Analytics Interview Write a query to find all orders placed on weekends versus weekdays and compare average order value. Read more ★ Save
Data Analytics Interview Write a query to return the department with the highest average tenure of employees. Read more ★ Save
Data Analytics Interview Write a query to calculate month-over-month growth rate in active users from a DailyActiveUsers table. Read more ★ Save
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 to detect gaps in a sequential invoice_number column. 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