Use PERCENT_RANK to show where each server log's response_time_ms falls on a 0-to-1 scale within its
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
Problem
Use PERCENT_RANK to show where each server log's response_time_ms falls on a 0-to-1 scale within its server_name. Order by response time ascending.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.