Data Analytics Interview Write a query to list all foreign keys referencing a given table in a schema (engine-specific system tables allowed). Read more ★ Save
Data Analytics Interview Write a query to find the top-selling product in each store location for the current quarter. Read more ★ Save
Data Analytics Interview Write a query to find the average time between a support ticket being opened and first responded to, grouped by priority. Read more ★ Save
Data Analytics Interview Write a query to find the second most frequently ordered item for each customer. Read more ★ Save
Data Analytics Interview Write a query to find all students who scored above the class average in more than 3 subjects. Read more ★ Save
Data Analytics Interview Write a query to identify vendors whose invoice amounts differ by more than 15% from their historical average. Read more ★ Save
Data Analytics Interview Write a query to compute year-over-year revenue comparison for each region using self-joins. Read more ★ Save
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 calculate month-over-month growth rate in active users from a DailyActiveUsers table. Read more ★ Save