Question: Need Help on These Queries Please! Queries to write: AGGREGATE Functions 1. List the sum of all the low stock prices that are below 60
Need Help on These Queries Please!
Queries to write: AGGREGATE Functions 1. List the sum of all the low stock prices that are below 60 dollars. Call it TotalLowUnder60. 2. List the earliest trade date of the stock that ended up having a high over 100 dollars. Add your own descriptive alias. 3. List each ticker symbol and the average daily trade volume for that stock. Order the list from highest to least daily trade volume. Add your own descriptive alias. 4. List the highest high price of all the stocks that have been traded in 2018 and have a low price less than 100 dollars. Add your own descriptive alias. 5. List the number of stocks that have an opening price of 70 dollars and were traded in 2018. Add your own descriptive alias. 6. List the ten most common closing prices along with the number of times each occurs. Add your own descriptive alias. 7. List the largest single-day stock price increase for Ford (between the market opening and closing). Add your own descriptive alias. 8. List the highest closing price for Ford in 2018. Add your own descriptive alias. 9. List the number of days in the table when a trade occurred (when the trade volume for any stock wasnt zero). Add your own descriptive alias. 10. List the number of days in the table when a trade occurred (when the trade volume for any stock wasnt zero) for each ticker symbol. Add your own descriptive alias. 11. Suppose we have a theory that Ford stocks dropped in value after the WHO officially declares Covid-19 a pandemic on Mar 11, 2020. List the minimum closing price of Ford stock in March 2020 before March 11. Add your own descriptive alias. 12. Now list the minimum closing price of Ford stock in just March 2020 after March Add your own descriptive alias. Does your theory hold true? 13. List the number of times you could have made at least a 10% profit by purchasing stocks at its lowest price for the day and selling the stock at its highest price for the day. Add your own descriptive alias. (Hint: Youll have to calculate 10% profit first).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
