SQL Challenges · THE GREAT DUCK MIGRATION!
Age Division Protocol
Difficulty: medium
Coach Waddles gathers everyone for formation assignments. Age matters for migration survival! Juniors (under 5) need protection in the center. Prime athletes (5-7) fly in formation wings. Veterans (8+) lead with experience. Find all Prime-age athletes - theyll form our powerful outer formations for maximum flock protection!
Your task
Return the sum of SSNs for all athletes in the "Prime" age category (age 5, 6, or 7). You will be working with the `duck_athletes` table to categorize athletes by age groups.