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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!