← Interview questions
Robinhood logo

Inactive Traders

Robinhood·easy·SQL

Find all users who signed up more than 30 days ago but have never placed a trade. Return their user_id, name, and signup_date, ordered by signup date ascending.

Schema

users
user_idINTEGER
nameVARCHAR
cityVARCHAR
signup_dateDATE
trades
trade_idINTEGER
user_idINTEGER
symbolVARCHAR
quantityINTEGER
priceDECIMAL
trade_dateDATE

Target output

Target output
user_idnamesignup_date
11Tina Alvarez2023-11-02
3Sarah Chen2024-01-05
7Marcus Webb2024-01-19
Queryusers, trades
Cmd+Enterto runLoading...
Output

Loading sample data...