Please use the stocksdb database. You may choose necessary fields to display (in addition to those indicated) and sort the data as you deem appropriate. You may find the entity-relationship diagram listing the tables with various fields and relationships among tables useful in thinking through the queries. Each of these queries should take no more than 10 minutes to formulate. Feel free to contact me if you need any assistance. It may be convenient to write the query on paper and then try it on the MySQL database.

Find the average EPS for all industries listed in the stock table

List the stock symbol and the number of times it has been traded.

List the stock symbol and its average historic price (from the historical prices table)

List the total worth (value) of each account. (hint: value of each holding in the portfolio can be calucalted by multiplying the quantity in the potfolio table and the current price in the stock table)

List the total worth (value) of each account of customer Virginia Russell (See hint for query 4)

Create two queries of your own that answers interesting business questions that may help in decision making. These queries should use more than one table, use aggregation operators and must be different from the ones we have seen in class or assignments.