Using the relation from Exercise 5.9, write an SQL query to generate a report showing the number

Question:

Using the relation from Exercise 5.9, write an SQL query to generate a report showing the number of shares traded, number of trades, and total dollar volume broken down by year, each month of each year, and each trading day.

Exercise 5.9

Given a relation nyse(year, month, day, shares traded, dollar volume) with trading data from the New York Stock Exchange, list each trading day in order of number of shares traded, and show each day’s rank.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 9780078022159

7th Edition

Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan

Question Posted: