Data Analytics Interview Write a query to compute the cumulative distinct count of new customers acquired each month. Read more ★ Save
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 identify products frequently bought together, based on an OrderItems table. 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 detect accounts with more than 5 failed login attempts within a 10-minute window. 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 find the longest streak of consecutive days a user logged into an app. 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 identify employees who have never taken a single day of leave in the last two years. Read more ★ Save