Top Endpoint by Power Users

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

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

Our platform team calls someone a power user of an endpoint when standard methods (GET, POST, PUT, DELETE) make up at least half of their calls to that endpoint. Find the endpoint with the most power users, and return it with that count.

Summary

Power users have a favorite endpoint.

Practice This Problem

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