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

1. Your business user asks you to show them a table that includes the number of trades for each firm and symbol combination in the data table above.
   1. Please write the SQL query you would use to query this table.
   2. Please show the exact results you expect based on your SQL query.Based on the data table above, your business user asks you to create a report that shows, for each firm, the symbols they traded and the total dollar volume they traded in that symbol.

B. Based on the data table above, your business user asks you to create a report that shows, for each firm, the symbols they traded and the total dollar volume they traded in that symbol. Please write the business requirements and corresponding functional specifications for this business request in the following format

BR #	Business Requirement	Functional Specification