Technical interview questions and drills

19 results across 1 active filter

Page 1 of 1

Showing the SQL Practical Query Problems curriculum. Technology tags describe each drill's actual implementation context; shared drills can belong to more than one track.

Coding problemMedium~25 min

Avoid double-counting payments and refunds

Pre-aggregates two one-to-many relationships before joining them to prevent fanout from corrupting financial totals.

In SQL Practical Query ProblemsShared across 4 tracks

SQLSQL Server

Drills

Avoid double-counting payments and refunds

Build daily order KPIs with conditional aggregation

Calculate a running account balance

Calculate seven-day rolling revenue

Detect overlapping bookings for a resource

Filter orders by line item without duplicate orders

Find duplicate normalized email addresses

Find each user's longest login streak

Find products matching every selected tag

Find users who have never placed an order

Flatten a category tree with a recursive CTE

Page orders with a stable keyset cursor

Query a local business date with a SARGable UTC range

Read an execution plan for a slow SQL query

Remove duplicate imports while keeping the newest row

Reserve inventory with one atomic conditional update

Return paid order totals for active customers

Return the latest status for every order

Return the top three products in each category