Loading interview...

API Traffic by CDN Edge

A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
medium
Seniority
mid

Interview Prompt

The CDN team is analyzing API traffic efficiency across edge locations. For request paths that include 'api', compute the average bytes served at each edge location and path combination. Only include edge locations that have delivered at least one cache hit across any path. Return the edge location, request path, and average bytes, from lowest average to highest.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision