# Hometown Performance Analysis

THE GREAT DUCK MIGRATION! · challenge 31 · medium

> Mayor Mallory presents hometown performance statistics. "Regional excellence drives migration success! Hometowns whose athletes average above the global performance mean produce superior talent. Athletes from these elite regions carry regional pride into battle. Sum their identification codes for the hometown champions registry!"

## Task

Return the sum of SSNs for all ducks from hometowns where the average score of their athletes exceeds the global average score across all competitions. You will be working with the `duck_athletes` and `performance_records` tables.

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

## Answer

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