Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Table Name: TRADES FIRM SYMBOLSIDE DATE 2/3/2014 1ABC A123B 2/4/2014 2BCD B234 B 2/7/2014 1ABC C345 2/10/2014 3CDE C345S 2/12/2014 4DEF 2/14/2014 3CDE B234 B
Table Name: TRADES FIRM SYMBOLSIDE DATE 2/3/2014 1ABC A123B 2/4/2014 2BCD B234 B 2/7/2014 1ABC C345 2/10/2014 3CDE C345S 2/12/2014 4DEF 2/14/2014 3CDE B234 B 2/21/2014 1ABC A123 B 2/24/2014 1ABC A123 S 2/25/2014 4DEF 2/27/2014 CDE QUANTITY PRICE 200 600 600 600 200 300 300 300 2100 1100 60 70 70 62 61 40 30 71 63 B234 C345 B234 C. 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 a. Please write the SQL query you would use to query this table b. 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 A. Please write the business requirements and corresponding functional specifications for this business request in the following format BR # | Business Requirement Functional Specification
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started