# Everything, Everywhere, All at Once

THE CLOUD EXPEDITION! · level 20 · chapter 7

Every character gathers at the edge of Pondville — Shellbert, Cloudsworth, Marina, Aria, Chronos, and Dr. Velocity. Captain Cloudsworth wipes a tear: 'Five paradigms. One query. This is your MAGNUM OPUS, Duckbert.' The crowd holds its breath. The ultimate test of <span class='feature-highlight'>All Five Paradigms</span> — local, cloud, shared, external files, and time travel in a single query.

## Task

Unite all five paradigms in one query. Find the most well-traveled Pondville ducks, enriched with ecosystem quality, storm impact, and archived census data. Return <b>name</b>, <b>home_pond</b>, <b>ponds_explored</b> (distinct destinations), <b>avg_water_quality</b> (from ecosystem readings at destinations), <b>total_storm_pop_change</b> (total population shift across all districts from the storm), and <b>archived_total_pop</b> (total population from the Parquet census archive). Most-explored ducks first, 10 rows. Tables: `pondville_residents` (local), `dbquacks_cloud_expedition.duck_travels` (cloud, linked by `duck_id`), `dbquacks_marina_lake.ecosystem_readings` (shared, `pond_name` matches `destination_pond`), `dbquacks_living_lake.pond_census` (Ducklake, version 1 = pre-storm), and `read_parquet('https://data.dbquacks.com/archives/census_2025.parquet')` for the census archive.<br><br><b>Re-attach if needed:</b><ul><li><code>dbquacks_marina_lake</code> → <code>md:_share/marina_lake_db/3be07852-dfce-4b29-b415-99c9f7fdcc6a</code></li></ul>

## Hint

Build a CTE for each paradigm you've learned, then combine them

## Expected result

Top 10 ducks with columns: name, home_pond, ponds_explored, avg_water_quality, total_storm_pop_change, archived_total_pop

## Tables

### `lake_visits` (500 rows)

| column | type |
| --- | --- |
| visit_id | BIGINT |
| duck_id | BIGINT |
| destination_pond | VARCHAR |
| visit_date | DATE |
| purpose | VARCHAR |

### `pondville_events` (50 rows)

| column | type |
| --- | --- |
| event_id | BIGINT |
| event_name | VARCHAR |
| event_date | DATE |
| organizer_id | BIGINT |
| location | VARCHAR |
| attendee_count | BIGINT |

### `pondville_residents` (100 rows)

| column | type |
| --- | --- |
| duck_id | BIGINT |
| name | VARCHAR |
| species | VARCHAR |
| home_pond | VARCHAR |
| age | BIGINT |
| occupation | VARCHAR |
| joined_date | DATE |

### `dbquacks_cloud_expedition.duck_travels`

A table in a MotherDuck share; its columns are not listed here.

### `dbquacks_marina_lake.ecosystem_readings`

A table in a MotherDuck share; its columns are not listed here.

### `dbquacks_living_lake.pond_census`

A table in a MotherDuck share; its columns are not listed here.

## Data

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

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

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

This level also queries MotherDuck shares, which need a MotherDuck token. On the page, the editor asks for one.

Play it in the browser: https://dbquacks.com/motherduck/20

## Reference

https://motherduck.com/docs/concepts/architecture-and-capabilities/