Catalog
8 branches of analytics, product and AI interview questions
Explore eight skill tracks, called branches, filterable by subtopic, company, tool and difficulty. SQL questions run against sample tables, choice and numeric answers are checked instantly, and written cases are scored against evaluation criteria.
Filters (3)
Branches
Subtopics
Access
Free onlyQuestion type
Type to find a company, then pick it from the list below.
Tool
2 questions
Trailing 7-day active users
ProFrom 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
Rolling seven-day cancellation rate
ProFor 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