Practice Robinhood SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Filter the orders dataset to retain only completed transactions.
Join the filtered orders with the users table to associate each trade with a city.
Group by city, count the completed trades, and return the top three locations sorted by volume.

What This Tests

Conditional filtering combined with multi-table joins
Group-level aggregation and counting
Deterministic sorting with tie-breaking logic
Handling edge cases such as empty result sets or insufficient data

Common Patterns

Inner Join

Aggregation

Groupby

Sort

Test Cases

Input

-

Output

-

Expected

-