easySQL & Data
Top Earner Per Department
Return the deterministic highest salary row in every department.
Practice challengeCodeArena challenge library
12 challenges match your filters.
easySQL & Data
Highest Score Per Cohort
Return the stable highest assessment score per learner cohort.
Practice challengemediumSQL & Data
Largest Order Per Seller
Return the highest-value order per seller with stable ties.
Practice challengehardSQL & Data
Latest Funding Amount Per Country
Return the largest funding record per destination.
Practice challengeeasySQL & Data
Seven-Period Engagement Sum
Compute rolling engagement totals over a fixed period window.
Practice challengeeasySQL & Data
Rolling Revenue Window
Compute an inclusive rolling revenue sum.
Practice challengemediumSQL & Data
Rolling Completion Volume
Produce a rolling completion total for ordered periods.
Practice challengehardSQL & Data
Rolling Support Load
Compute rolling support-case volume.
Practice challengeeasySQL & Data
Latest Application Status
Keep the latest status record for every application.
Practice challengeeasySQL & Data
Latest Credential Version
Deduplicate credentials to their latest version.
Practice challengemediumSQL & Data
Latest Seller Policy
Return the newest policy row per seller.
Practice challengehardSQL & Data
Latest Source Review
Keep the latest official-source review per source key.
Practice challenge