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.

One or more of the queries may not return any records because there may not records that match all the conditions.

Display the names of agents who manage special accounts. (any Account that is not "Standard")

Display customer name and Roth Account ID for those customers who own Roth Accounts

Display Historical prices for Apple Computers; Order results by date

Display Historical prices for Software Industry Stocks; Order results by Company name and date

Display company name, customer name, type, date, price and quantity for each stock transaction; order the results by customer name and company name

Display all software stock transactions for male customers older than 20

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 and must be different from the ones we have seen in class or assignments.