Target practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
Target
Explore 3 Target-tagged SQL scenarios focused on filtering, aggregation, joins.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
3
Estimated prep time
75 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Target-tagged set.
Filtering
3
Aggregation
1
Joins
1
Query basics
1
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
Top Purchase per Customer
Practice query basics through a Target-tagged business scenario.
Source Target ID Reconciliation
Practice joins through a Target-tagged business scenario.
9904 Highest Target
Practice aggregation through a Target-tagged business scenario.
Question list
The current Target-tagged list with learning objectives and your latest status.
Top Purchase per Customer
Return each user_id with the purchase_id and amount of that user’s most expensive purchase. If two purchases tie on amount, keep the earlier purchased_at row...
Practice query basics through a Target-tagged business scenario.
Source Target ID Reconciliation
Given two tables source and target, identify the following: IDs present in the source table but not in the target table. IDs present in the target table but ...
Practice joins through a Target-tagged business scenario.
9904 Highest Target
WITH ranked_targets as ( SELECT first_name, target, bonus, DENSE_RANK() OVER(ORDER BY target desc) as rn FROM employee ) SELECT first_name, target, bonus FRO...
Practice aggregation through a Target-tagged business scenario.