SQL Database Queries for Stocks and Trades

MSF 503:HOMEWORK 3Name: Pablo Diego Maristany TYPE YOUR ANSWERS INTO A WORD.doc AND SUBMIT IT. For Questions 1-5, use the following database, where ?= primary key: IBM Date ? OpenPriceHighPriceLowPriceClosePrice Volume 1/2/199023.5424.3823.4824.35176060 0 1/3/199024.5324.7224.4424.56236940 0 1/4/199024.6024.9424.5624.84242360 0 1/5/199024.8125.2524.7224.78189390 0 1/8/199024.6625.0624.6624.941159800 1/9/199024.9725.1624.6924.69176310 0 1/10/199024.7224.8424.5024.60149000 0 1/11/199024.7224.9424.6924.81148000 0 1/12/199024.5024.6624.2524.32135200 0 1/15/199024.2524.4424.1624.38101390 0 1.What SQL statement would you use to retrieve the average Volume per day for the week of January 8, 1990?+ SELECT AVG (Volume) FROM IBM WHERE Date BETWEEN '1/8/1990' AND '1/12/1990' 2.What SQL statement would you use to insert a new row?+ INSERT INTO IBM (Date, Open Price, High Price, Low Price, Close Price, Volume) VALUES (...) 3.What data would the following SQL statement do?+ SELECT * FROM IBM WHERE ClosePrice > 24.50 ORDER BY ClosePrice Selects the rows whose close price is higher than 24.50$.