Skill: temporal tabular reasoning

[Case 2]

• Initial Environment: The same sports-results environment stores athlete birth information and dated medal events. The answer depends on aligning event time to athlete age.
• Real Question: At what age did Michael Phelps win his most recent Olympic Gold Medal?
• Real Answer: The SQL must identify the most recent qualifying gold-medal event first and only then compute age at that event date.
• Why this demonstrates the capability: This task is easy to get wrong if the order of temporal operations is reversed. A model that computes age on the wrong event or ignores the recency constraint will still produce fluent SQL but the wrong answer. That makes it a strong temporal reasoning probe for SQL agents.

Pipeline Execution Instructions

To synthesize data for this capability, you must strictly follow a 3-phase pipeline. Do not hallucinate steps. Read the corresponding reference file for each phase sequentially:

1. Phase 1: Environment Exploration Read the exploration guidelines to discover raw knowledge seeds: references/EXPLORATION.md

2. Phase 2: Trajectory Selection Once Phase 1 is complete, read the selection criteria to evaluate the trajectory: references/SELECTION.md

3. Phase 3: Data Synthesis Once a trajectory passes Phase 2, read the synthesis instructions to generate the final data: references/SYNTHESIS.md