The Warm Edges

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The CDN team is comparing API traffic at the edge locations that are actually caching: those that have logged at least one cache hit on any path. For request paths that include 'api', find the average bytes served at each of those edge locations and path combination, from the lowest average to the highest.

Summary

Some edges keep the cache warm. Measure what they carry.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.