Peak Visitor Day for Each Trail

Problem

A national park logs the number of hikers counted on each trail every day. Table `trail_log` has columns `(trail_id, log_date, hikers)`.

For every trail, report the day on which it recorded its highest hiker count. If the same peak count occurred on more than one day, report the earliest of those days.

Return the columns `trail_id`, `log_date`, and `hikers`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns trail_id, log_date, hikers.

Starter code (SQL)

SELECT *
FROM trail_log;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium