Only the Big Ones
Return every column of the trades whose qty is more than 100. Rows may come in any order.
Example 1
trades
| id | symbol | qty | price |
|---|---|---|---|
| 1 | AAPL | 250 | 190.5 |
| 2 | MSFT | 100 | 410.0 |
| 3 | NVDA | 40 | 120.25 |
| 4 | AAPL | 101 | 191.0 |
returns
| id | symbol | qty | price |
|---|---|---|---|
| 1 | AAPL | 250 | 190.5 |
| 4 | AAPL | 101 | 191.0 |
Constraints
- Up to 12 trades
Write it in your browser, against the clock. The model query, with a note on each piece of it, comes after.
More SQL problems
- Starts With ABeginner
- Three LargestBeginner
- Trade ValueBeginner
- Two ColumnsBeginner
- Average per SymbolEasy
- Biggest SpenderEasy
- Bought and SoldEasy
- Busy SymbolsEasy