CDN Traffic by Day and Hour

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The infra team is sizing CDN edge capacity and wants a throughput heatmap across the week, broken out by weekday and hour of day. For every weekday-and-hour pairing find the average net bytes per request, where net bytes is the gross bytes left after a flat 5 percent transfer overhead is removed; spell the weekday out in full like 'Monday', round the average to two decimals, and lay the rows out in calendar order starting with Sunday, then by hour.

Summary

CDN traffic, hour by hour.

Practice This Problem

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