Question: Data 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
Data 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 |
Q3. Your business user asks you to tell them the unique firm and symbol combinations 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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
