Skip to content

Tracks Drills Topics Technologies Tech stacks Skill areas

Tracks Drills Guides

Loading

Aporeon

Technical interview practice, from one developer to another.

Guides About Editorial standards Support Privacy Terms Refund policy

SQL Practice - .NET Full Stack | Aporeon

.NET Full Stack

SQL Practice

Hands-on SQL query problems for product data, reporting, pagination, correctness, and performance.

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 OrdersUses 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