# Hometown Pride Count

THE GREAT DUCK MIGRATION! · challenge 8 · easy

> Mayor Mallory waddles over with the town census and ceremonial scrolls. "Pondville has always been the heart of athletic excellence since our founding! Before we depart on this perilous migration, we must honor our local champions properly. Sum the identification codes of all athletes from Pondville in our elite roster - their hometown needs to prepare the right hero medals and arrange the farewell parade before the great journey begins!"

## Task

Return the sum of SSNs for all ducks from Pondville in the athletes registry. You will be working with the `duck_athletes` table to sum hometown representation.

## 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/8

## Answer

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