compute the weighted average (instead of the average) yield by nation (yield is defined as dividend...

Transcribed Image Text:

compute the weighted average (instead of the average) yield by nation (yield is defined as dividend divided by price, and is reported as a percentage). The weighted average includes the quantity of shares as a weight 1 Firm's code Firm's name Price Quantity Dividend pe nationID 2 FC Freedonia Copper 27.50 10529 1.84 16 1 3 PT Patagonian Tea 55.25 12635 2.50 10 1 4 AR Abyssinian Ruby 31.82 22010 1.32 13 1 5 SLG Sri Lankan Gold 50.37 32868 2.68 16 1 6 ILZ Indian Lead and Zinc 37.75 6390 3.00 12 1 Burmese Elephant Bolivian Sheep 7 BE 0.07 154713 0.01 1 8 BS 12.75 231678 1.78 11 1 Nigerian Geese Canadian Sugar 9 NG 35.00 12323 1.68 10 1 10 CS 52.78 4716 2.50 15 1 11 ROF Royal Ostric Farms 33.75 1234923 3.00 1 12 MG Minnesota Gold 53.87 816122 1.00 25 2 13 GP Georgia Peach 2.35 387333 0.20 14 NE Narembeen Emu 12.34 45619 1.00 8 15 QD Queensland Dia ond 6.73 89251 0.50 20 3 Indoorpilly Ruby Bombay Duck 16 IR 15.92 56147 0.50 20 17 BD 25.55 167382 1.00 12 4 18 19 A B 1 code 2 UK nationName exchangeRate United Kingdom 1 3 USA United States 0.67 4 AUS Australia 0.46 5 IND India 0.02 compute the weighted average (instead of the average) yield by nation (yield is defined as dividend divided by price, and is reported as a percentage). The weighted average includes the quantity of shares as a weight 1 Firm's code Firm's name Price Quantity Dividend pe nationID 2 FC Freedonia Copper 27.50 10529 1.84 16 1 3 PT Patagonian Tea 55.25 12635 2.50 10 1 4 AR Abyssinian Ruby 31.82 22010 1.32 13 1 5 SLG Sri Lankan Gold 50.37 32868 2.68 16 1 6 ILZ Indian Lead and Zinc 37.75 6390 3.00 12 1 Burmese Elephant Bolivian Sheep 7 BE 0.07 154713 0.01 1 8 BS 12.75 231678 1.78 11 1 Nigerian Geese Canadian Sugar 9 NG 35.00 12323 1.68 10 1 10 CS 52.78 4716 2.50 15 1 11 ROF Royal Ostric Farms 33.75 1234923 3.00 1 12 MG Minnesota Gold 53.87 816122 1.00 25 2 13 GP Georgia Peach 2.35 387333 0.20 14 NE Narembeen Emu 12.34 45619 1.00 8 15 QD Queensland Dia ond 6.73 89251 0.50 20 3 Indoorpilly Ruby Bombay Duck 16 IR 15.92 56147 0.50 20 17 BD 25.55 167382 1.00 12 4 18 19 A B 1 code 2 UK nationName exchangeRate United Kingdom 1 3 USA United States 0.67 4 AUS Australia 0.46 5 IND India 0.02

Answer rating: 100% (QA)

first create the tables with given information with following code table shares CREATE TABLE shares ID Integer firmscode Text PRIMARY KEY firmsname TE... View the full answer