Each Symbol Once
List the symbols that appear in trades, each one once, in alphabetical order.
Example 1
trades
| id | symbol | qty | price |
|---|---|---|---|
| 1 | MSFT | 10 | 410.0 |
| 2 | AAPL | 5 | 190.5 |
| 3 | MSFT | 7 | 411.0 |
| 4 | KO | 1 | 61.2 |
returns
| symbol |
|---|
| AAPL |
| KO |
| MSFT |
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
- How Many SellsBeginner
- No ManagerBeginner
- One SymbolBeginner
- One of SeveralBeginner
- Only the Big OnesBeginner
- Starts With ABeginner
- Three LargestBeginner
- Trade ValueBeginner