# Name Analysis for Roster Organization

THE GREAT DUCK MIGRATION! · challenge 27 · 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 formation will inspire courage in every wing behind them!"

## 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.

## Tables

### `duck_athletes` (50 rows)

| column | type |
| --- | --- |
| id | BIGINT |
| ssn | BIGINT |
| name | VARCHAR |
| age | BIGINT |
| hometown | VARCHAR |

## Data

The tables live in a DuckDB database: https://dbquacks.com/data/databases/athletic_champions.duckdb

To query it outside the browser, attach it read-only:

```sql
ATTACH 'https://dbquacks.com/data/databases/athletic_champions.duckdb' AS db (READ_ONLY);
USE db;
```

Play it in the browser: https://dbquacks.com/challenges/athletic/27

## Answer

The expected answer is not published. Submit on the page to have it checked.