Top Endpoint by Power Users

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

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

A power user is someone whose calls to standard methods (GET, POST, PUT, DELETE) make up at least 50% of their total calls. Find the endpoint where the most power users are active. Return the endpoint and the power user 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 grades it automatically.