Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For every direct holder , list the first and last name, the names of the companies this person owns, the number of shares currently held,
For every direct holder, list the first and last name, the names of the companies this person owns, the number of shares currently held, % this holder has of the shares outstanding, and % this holder has of the total authorized shares. Sort the output by direct holder last name, first name, and company name. Display the percentages to two decimal places.
Currency PK currency_id Shareholder Place PK shareholder id U1 name U2 symbol PK place id -H- city- country Current_Shareholder Shares shareholder_id type stock_id shares type Conversion PK,FK1 from currency id PK,FK2 to currency id Current_Stock Stats stock_id current_authorized total_outstanding exchange_rate Trade Direct_Holder PK trade id Stock_Exchange FK2 stock_id PK stock ex id transaction_time shares name HO--- OFK1 stock_ex_id symbol price_total FK2 currency_id FK4 buyer_id FK1 place_id FK5 seller_id FK3 buy_broker_id FK6 sell_broker_id Company PK,FK2 company id PK,FK1(direct holder id O-H U2 FK1 U1 first_name last_name name place_id stock_id starting_price currency_id Broker PK broker.id 18 first_name last_name Stock_Listing O PK,FK2 stock ex id PK,FK1 stock id Shares Authorized PK,FK1 stock id PK time start stock_symbol Broker Stock Ex time_end authorized PK,FK1 stock ex id PK,FK2 broker.id Stock_Price PK,FK1 stock ex id PK,FK2 stock id time start time_end priceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started