8 branches of analytics, product and AI interview questions

Rank orders per customer and return each customer's second largest order.

Live SQL · Windows · PostgreSQL · 12 min · Medium

SQL & Data Modeling · Original Uplift question

From the orders table, return each order_date with that day's revenue and a cumulative running total of revenue through that date, ordered by date.

Live SQL · Windows · PostgreSQL · 10 min · Medium

SQL & Data Modeling · Original Uplift question

From an events table, for each calendar date return the number of DISTINCT users active in the trailing 7 days (that date and the 6 days before it).

Live SQL · Windows · PostgreSQL · 15 min · Hard

SQL & Data Modeling · Original Uplift question

Return each month, its revenue, and the month-over-month growth as a percentage rounded to one decimal.

Live SQL · Windows · PostgreSQL · 10 min · Medium

SQL & Data Modeling · Original Uplift question

Return the top 3 products by total revenue within each category.

Live SQL · Windows · PostgreSQL · 12 min · Medium

SQL & Data Modeling · Original Uplift question

For each user, return the length of their longest streak of consecutive calendar months with at least one activity.

Live SQL · Windows · PostgreSQL · 18 min · Medium

SQL & Data Modeling · Original Uplift question

For every calendar date from the first through last order date, compute the trailing seven-calendar-day cancellation rate: canceled orders divided by all orders in that date and the prior six dates.

Live SQL · Windows · PostgreSQL · 22 min · Hard

SQL & Data Modeling · Original Uplift question