#Hard

Median of Two Sorted Arrays

Median of Two Sorted Arrays (LeetCode 4): binary search a partition of the smaller array for O(log(min(m,n))) time.

Write a query to compute the cumulative distinct count of new customers acquired each month.

Write a query to identify products frequently bought together, based on an OrderItems table.

Write a query to detect accounts with more than 5 failed login attempts within a 10-minute window.

Write a query to find the longest streak of consecutive days a user logged into an app.

Write a query to detect gaps in a sequential invoice_number column.

Write a query that returns customers whose total spend is above the 90th percentile of all customers.

Write a query to calculate the running total of daily revenue for a store using a self-join.