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

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!