Popular Exhibit-to-Exhibit Routes

Problem

A science museum logs each exhibit a visitor finishes in the table `exhibit_visits`, with the `visitor_id`, the `exhibit_id`, the `exhibit_name`, the `visited_at` timestamp, and the `enjoyment` score (1 to 5) the visitor gave that exhibit. The curators want walking routes from the museum's *enthusiasts* only: visitors who finished at least 5 exhibits AND whose average enjoyment is at least 4. For those visitors, look at each pair of exhibits visited back-to-back (the exhibit visited immediately after another, in time order), and count how often each such ordered pair occurs across all enthusiasts. Return `from_exhibit`, `to_exhibit`, and the occurrence count as `route_count`. Order by `route_count` descending, then by `from_exhibit` ascending, then by `to_exhibit` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns from_exhibit, to_exhibit, route_count.

Starter code (SQL)

SELECT *
FROM exhibit_visits;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard