# Consistent Excellence Search

THE GREAT DUCK MIGRATION! · challenge 10 · medium

> Scout Samantha arrives with endurance charts and reliability metrics. "The migration isn't just about peak performance - it's about unwavering consistency! Through storms, predators, and exhaustion, we need ducks who NEVER fail under pressure. Find all athletes who have NEVER scored below 70.00 in any competition ever. These steady, reliable performers will maintain perfect V-formation during the entire grueling 3,000-mile journey without faltering!"

## Task

Return the sum of SSNs for all ducks who have never scored below 70.00 in any of their competitions (ducks with no performance records should not be included). You will be working with the `duck_athletes` and `performance_records` tables to find consistently excellent performers.

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

## Answer

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