Scenario

You work with a mountain climbing registry that tracks which climbers have summited each mountain and when.

Task

Write a Snowflake SQL query that:

1. Joins {{ ref("climbers") }} with {{ ref("mountains") }} on the mountain name
2. For each mountain, finds the climber with the most recent climb_date
3. Returns mountain_name, the climber's name as last_climber_name, the date as last_climb_date, and the time as last_climb_time
4. Excludes any mountains that have no climbing records

Schema

mountains

climbers

Example

mountains:

climbers:

Expected Output:

Note: Mount Olympus has no climbing records, so it does not appear in the output. For each mountain with climbers, only the row with the most recent climb_date is returned.