Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Display the trade id, name of the company and number of shares for the single largest trade made on the secondary markets in terms of

Display the trade id, name of the company and number of shares for the single largest trade made on the secondary markets in terms of the number of shares traded. Unless there are multiple trades with the same number of shares traded, only one row should be returned.

image text in transcribed

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 price

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database Technology

Authors: Suad Alagic

1st Edition

354096276X, 978-3540962762

More Books

Students also viewed these Databases questions