Question: Dats table Table Name: TRADES DATE FIRM SYMBOL SIDE QUANTITY PRICE 2/3/2014 1ABC A123 B 200 41 2/4/2014 2BCD B234 B 600 60 2/7/2014 1ABC
Dats table
Table Name: TRADES
| DATE | FIRM | SYMBOL | SIDE | QUANTITY | PRICE |
| 2/3/2014 | 1ABC | A123 | B | 200 | 41 |
| 2/4/2014 | 2BCD | B234 | B | 600 | 60 |
| 2/7/2014 | 1ABC | C345 | S | 600 | 70 |
| 2/10/2014 | 3CDE | C345 | S | 600 | 70 |
| 2/12/2014 | 4DEF | B234 | B | 200 | 62 |
| 2/14/2014 | 3CDE | B234 | B | 300 | 61 |
| 2/21/2014 | 1ABC | A123 | B | 300 | 40 |
| 2/24/2014 | 1ABC | A123 | S | 300 | 30 |
| 2/25/2014 | 4DEF | C345 | B | 2100 | 71 |
| 2/27/2014 | CDE | B234 | S | 1100 | 63 |
Data Observation and Description:
Q2. Your business user asks you to tell them the unique symbols in the data table above. Please write the SQL query you would use to query this table. Please show the exact results you expect based on your SQL query
| Symbol |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
