# Quack to the Future

THE CLOUD EXPEDITION! · level 15 · chapter 6

A shimmering lake pulses with light. An ancient duck materializes from the mist — Chronos the Timekeeper. 'Every change leaves a shadow,' he intones. 'Ducklake remembers what others forget. Step into the past... if you dare.' Welcome to <span class='feature-highlight'>Time Travel</span> — querying historical snapshots of a Ducklake table.

## Task

Look back in time to the pre-storm census. Query the original snapshot (version 1) of the pond census, returning all columns ordered by population descending. Use the `AT (VERSION => 1)` syntax after the table name. Table: `dbquacks_living_lake.pond_census` (Ducklake).

## Hint

Add AT (VERSION => 1) after the table name to query a historical snapshot

## Expected result

All rows from the pre-storm census (version 1) with columns like district, population, and water_level ordered by population descending

## 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_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/15

## Reference

https://ducklake.select/docs/stable/duckdb/usage/time_travel