Oracle SQL

3,4,5. I know this is hard without the erd but if I could please get some general answer or answer close to it. Thanks a lot

Write a query which lists the name of every company that has authorized stock, the number of shares currently authorized, the total shares currently outstanding, and % of authorized shares that are outstanding Shares outstanding is the number of shares owned by external share holders. Shares-Authorized = Shares Outstanding + Shares-Unissued ery direct holder: list the name of the holder, the names of the companies invested in bythis direct holder, num ber of shares cur outstanding, and % this holderhas ofthet talauthorized shares. holder last name, first name, and company name and display the percentages to two decimal places rently held, % this holder has of the shares Sort the output by direct 5. For every institutional holder (companies who hold stock): list the name of the holder, the names of the companies invested in by this holder, shares currently held, % this holderhas of the totalshares outstanding, and % this holder has of hat otal author zedShares For this report, include only the external holders (not treasury shares). Sort the output by holder name, and company owned name and display the percentages to two decimal places Write a query which displays all trades where more than 50000 shares were traded on the secondary markets. Please include the trade id, stock symbol, name of the company bein traded, stock exchange symbol, number of shares traded, price total (including broker fee and currency symbol k listed on each stock exchange, display the exchange name, stock symbo d time when that the stock was last traded. Sort the output by stock stock symbol. If a stock has not been traded show the exchange nam