SQL Challenges · THE GREAT DUCK MIGRATION!
Name Analysis for Roster Organization
Difficulty: easy
Professor Shellbert carefully unfurls an ancient migration scroll, its edges worn from centuries of use. According to the sacred migration texts, ducks whose names carry the letter A are blessed with the spirit of the Ancient Albatross - a legendary bird who guided the very first great migration through impossible storms! These blessed athletes must be summoned to perform the traditional Dawn Departure Ceremony. Their names echo through duck legend, and their presence at the front of our format…
Your task
Return the sum of SSNs for all ducks whose name contains the letter 'a' (case insensitive). You will be working with the `duck_athletes` table.