01 Easy Robinhood Cities With Completed Trades

Robinhood

Interview Core Track · Easy · 15 min

-- clients with completed trades -- SELECT u.city, COUNT(t.order_id) AS total_orders FROM trades AS t INNER JOIN users AS u ON t.user_id = u.user_id WHERE t....

Interview Core Track

Easy

15 min

joins

aggregation

filtering

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice joins through a Robinhood-tagged business scenario.

Approach

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

-- clients with completed trades -- SELECT u.city, COUNT(t.order_id) AS total_orders FROM trades AS t INNER JOIN users AS u ON t.user_id = u.user_id WHERE t.status = 'Completed' GROUP BY u.city ORDER BY total_orders DESC LIMIT 3;

users

user_id INT PRIMARY KEY

name VARCHAR(100

trades

order_id INT PRIMARY KEY

user_id INT REFERENCES users(user_id

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.