# PONDIFY WRAPPED

WEEKLY QUACK CHALLENGE! · challenge 10 · hard · 5 guesses

> Producer Pochard squints at the year-end streaming report. "The numbers don't lie, Duckbert — one artist showed up in every single duck's top five this year. But here's the twist: not one duck crowned them #1. They're the shadow hit of the pond. Find the secret artist."

## Task

For each duck, rank artists by play count. The secret hit is the one artist who sits in every duck’s top 5 yet is no duck’s number one. Return that artist’s name. You will be working with the `plays`, `tracks`, and `artists` tables.

## Tables

### `plays` (815 rows)

| column | type |
| --- | --- |
| duck_id | INTEGER |
| track_id | INTEGER |
| played_at | TIMESTAMP |

### `tracks` (16 rows)

| column | type |
| --- | --- |
| track_id | INTEGER |
| title | VARCHAR |
| artist_id | INTEGER |

### `artists` (8 rows)

| column | type |
| --- | --- |
| artist_id | INTEGER |
| name | VARCHAR |
| genre | VARCHAR |

## Data

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

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

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

Play it in the browser: https://dbquacks.com/challenges/weekly/10

## Answer

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