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_id | name | signup_date |
|---|
| 11 | Tina Alvarez | 2023-11-02 |
| 3 | Sarah Chen | 2024-01-05 |
| 7 | Marcus Webb | 2024-01-19 |
What this question tests
Tests the anti-join: finding rows in one table that have no match in another, plus a date cutoff. Interviewers use it to see whether you reach for NOT EXISTS or a LEFT JOIN with an IS NULL check rather than NOT IN, and whether you can express a rolling cutoff like more than 30 days ago cleanly.
More SQL interview questions
