Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Make efficient use of your practice time?

Answered: 1 week ago