Skip to content

Tracks Drills Topics Technologies Tech stacks Skill areas

Tracks Drills Topics

Loading

Aporeon interview preparation

About Privacy Terms

Query Practice

Hands-on SQL problems with concrete schemas, worked queries, edge cases, and execution reasoning.

18 drillsPractice one at a timeOrdered pathCoding problem

Recommended start

Paid Order Totals

Writes a left-join aggregate that keeps active customers with no paid orders and applies date filters without changing join semantics.

Easy~15 minStep 1 of 18

Practice this drill Choose another

Search

18 of 18 shown

1Paid Order TotalsRecommended startWrites a left-join aggregate that keeps active customers with no paid orders and applies date filters without changing join semantics.Coding problemEasy~15 minSQLSQL ServerPractice 2

Practice order

18 drillsOne at a time

1Paid Order TotalsUp next / Easy / ~15 min
2Users Without OrdersEasy / ~15 min
3Match Every TagMedium / ~25 min
4

Users Without Orders

Uses NOT EXISTS to express an anti-join without null traps or duplicate parent rows.

Coding problemEasy~15 minSQLSQL Server

Practice

3Match Every TagSolves a many-to-many all-match filter with grouping and a deliberate empty-selection rule.Coding problemMedium~25 minSQLSQL ServerPractice

4Booking OverlapImplements correct half-open interval overlap logic for booking validation.Coding problemMedium~25 minSQLSQL ServerPractice

5Filter Without DuplicatesUses EXISTS instead of a row-multiplying join when the related table is only a filter.Coding problemEasy~15 minSQLSQL ServerPractice

6Daily Order KPIsBuilds several daily business metrics in one grouped query while keeping each metric definition explicit.Coding problemMedium~25 minSQLSQL ServerPractice

7Duplicate EmailsGroups normalized email values to identify duplicates before adding or repairing a uniqueness rule.Coding problemEasy~15 minSQLSQL ServerPractice

8Avoid Fanout TotalsPre-aggregates two one-to-many relationships before joining them to prevent fanout from corrupting financial totals.Coding problemMedium~25 minSQLSQL ServerPractice

9Rolling RevenueCombines daily aggregation, a calendar table, and a window frame to calculate true seven-calendar-day revenue.Coding problemHard~35 minSQLSQL ServerPractice

10Latest Order StatusUses ROW_NUMBER with a deterministic tie-breaker to return the complete latest status row per order.Coding problemMedium~25 minSQLSQL ServerPractice

11Top Products Per CategoryAggregates product sales and ranks independently inside each category with a deterministic top-N rule.Coding problemMedium~25 minSQLSQL ServerPractice

12Keyset Order PageImplements descending keyset pagination with a compound cursor and stable ordering.Coding problemMedium~25 minSQLSQL ServerPractice

13Running BalanceUses an ordered window aggregate to calculate a deterministic running balance per account.Coding problemMedium~25 minSQLSQL ServerPractice

14Longest Login StreakUses the gaps-and-islands pattern to find consecutive login-day streaks after deduplicating same-day activity.Coding problemHard~35 minSQLSQL ServerPractice

15Category Tree PathsUses a recursive CTE to return hierarchy depth and a readable root-to-node path.Coding problemHard~35 minSQLSQL ServerPractice

16Local Date, UTC RangeConverts local-day boundaries to UTC once, preserving correct daylight-saving behavior and index use on stored UTC timestamps.Coding problemHard~35 minSQLSQL ServerPractice

17Atomic Inventory ReserveUses a conditional update and transaction to prevent overselling while recording the reservation consistently.Coding problemMedium~25 minSQLSQL ServerPractice

18Deduplicate ImportsRanks duplicate import rows, previews the deletion set, and removes older copies with deterministic retention.Coding problemMedium~25 minSQLSQL ServerPractice

Booking Overlap

Medium / ~25 min

5Filter Without DuplicatesEasy / ~15 min

6Daily Order KPIsMedium / ~25 min

7Duplicate EmailsEasy / ~15 min

8Avoid Fanout TotalsMedium / ~25 min

+10 more drills in this section

Query Practice - Database SQL | Aporeon