Practice Google SQL Question | Real Coding Interviews

Quick Summary

Calculate the median search count from a compressed frequency table where each row represents multiple users.
Handle both odd and even total user counts by averaging the two middle values when necessary.
Return the result rounded to one decimal place.

What This Tests

Working with aggregated or frequency-distributed data instead of granular records.
Determining positional indices within a logically expanded dataset.
Combining aggregate calculations with row-level filtering to isolate median candidates.
Handling edge cases like single-row tables or uniform distribution counts.

Common Patterns

Window Function

Cumulative Sum

Inner Join

Aggregation

Table: search_frequency

+------------+---------+
| Column Name| Type    |
+------------+---------+
| searches   | integer |
| num_users  | integer |
+------------+---------+
There is no primary key. Each row shows how many users (num_users) performed exactly searches searches last year.

Test Cases

Input

Output

Expected