# Veteran Navigator Search

THE GREAT DUCK MIGRATION! · challenge 4 · medium

> Dr. Stork approaches with ancient migration scrolls and historical records. "Experience saves lives during dangerous migrations! We need proven veterans - ducks who competed in the same sport across multiple years show dedication and consistency. Their reliability under pressure will guide younger ducks through storms and predator territories. Find our most dedicated multi-year athletes!"

## Task

Return the sum of SSNs for all ducks who competed in the same sport across 2 or more different years. You will be working with the `duck_athletes` and `performance_records` tables to find experienced multi-year athletes.

## Tables

### `performance_records` (800 rows)

| column | type |
| --- | --- |
| duck_id | BIGINT |
| sport | VARCHAR |
| score | DOUBLE |
| competition_date | DATE |

### `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/4

## Answer

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