Loading...
Cheapest CDN Route
A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- senior, staff
Problem
The cdn_logs table records hops between edge locations with an associated byte cost. Find the cheapest route from 'us-east' to 'eu-west', considering direct connections and paths with up to two intermediate stops. Normalize location names to lowercase. Return the cheapest total cost.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.