Find average GDP according to continent in SQL -
i have 2 tables- economics (land_code, gdp)
, continent (land_code, cont, percentage)
. need create query calculates average gross domestic product continent. in case country @ same time in several continents, should consider percentage of gross domestic product belongs continent. have understood if arab republic of egypt has gross domestic product of 100, 90 belongs africa , 10 asia
, how can implement expression?
!!! done)
obviously,
select economics.land_code, economics.gdp * continent.percentage ...
sql
No comments:
Post a Comment