Question
Given a stock table with column names: data,open,high,low,close,volunm,adjclose, and investmentvalue, write a SQL query that does the following: Compute the daily value of the investment,
Given a stock table with column names: data,open,high,low,close,volunm,adjclose, and investmentvalue, write a SQL query that does the following:
Compute the daily value of the investment, assuming dividends accumulate. A dividend is a sum of money a company pays quarterly to its shareholders. Look at the stock table for the dividend amount per share and the date of the dividend. Assume that the dividends accumulate in the account as cash and add them to the daily investment value between January 16, 2015 until June 17, 2016.
Here is the divident information:
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