SELECT n__year, SUM(n__exports_of_goods_and_services), SUM(n__imports_of_goods_and_services), SUM(n__gross_domestic_product_gdp)
FROM @kaggle.prasad22_global_economy_indicators.global_economy_indicators
GROUP BY n__year
n__year | sum(n__exports_of_goods_and_services) | sum(n__imports_of_goods_and_services) | sum(n__gross_domestic_product_gdp) |
---|---|---|---|
1970 | 383315364938 | 384156165293 | 3411564665244 |
1971 | 428194214840 | 427328645690 | 3753967631338 |
1972 | 506869766902 | 501282991902 | 4325757795073 |
1973 | 690874478708 | 680535635847 | 5265353899176 |
1974 | 954365145066 | 954208138362 | 5963783679185 |
1975 | 1010336109907 | 1010911254337 | 6660571008316 |
1976 | 1125823553354 | 1134828551506 | 7196687432583 |
1977 | 1272027152074 | 1302385314761 | 8098552420906 |
1978 | 1476852504710 | 1507706103823 | 9593172413875 |
1979 | 1851756696031 | 1885576544768 | 11051798672112 |
1980 | 2236749222368 | 2283140983267 | 12330103731349 |
1981 | 2249496844027 | 2300663693623 | 12588505644373 |
1982 | 2101445127315 | 2158936775618 | 12481916028426 |
1983 | 2084452928510 | 2132806606933 | 12799300712197 |
1984 | 2200761567605 | 2241790448187 | 13170134587431 |
1985 | 2205509788774 | 2242707233455 | 13518896709244 |
1986 | 2433658705778 | 2488374753313 | 15580018871945 |
1987 | 2864857006398 | 2904524419991 | 17606735851097 |
1988 | 3293034392903 | 3347888964722 | 19691435665018 |
1989 | 3541680177182 | 3623223430438 | 20566858778679 |
1990 | 4308744867392 | 4385445063885 | 23806149831681 |
1991 | 4410049090382 | 4441361295366 | 24005601921690 |
1992 | 5021327507524 | 4944301810171 | 25647108455548 |
1993 | 4861924861259 | 4753622538844 | 26099614451230 |
1994 | 5363375778838 | 5242345739693 | 27945148637763 |
1995 | 6317896201663 | 6181984773021 | 31002110287549 |
1996 | 6611810050442 | 6489162874570 | 31639452531300 |
1997 | 6863288794326 | 6713474720134 | 31469223892065 |
1998 | 6770735264600 | 6672298903843 | 31301977048472 |
1999 | 7038884312013 | 6966797177897 | 32483934979105 |
2000 | 7805584023545 | 7768512388696 | 33468728005307 |
2001 | 7582075506724 | 7599923246104 | 33288794571924 |
2002 | 7951947812796 | 7911309851135 | 34550626480582 |
2003 | 9236079505552 | 9186756142784 | 38886444344113 |
2004 | 11177876908765 | 11050522025340 | 43734569751756 |
2005 | 12729037165270 | 12549007797394 | 47368857426547 |
2006 | 14667663811460 | 14358171583727 | 51365365510447 |
2007 | 17058389749998 | 16667715064254 | 57977089925569 |
2008 | 19627223612771 | 19196835650539 | 63744457192601 |
2009 | 15792524721405 | 15431691260257 | 60462760027869 |
2010 | 18809145363261 | 18225748935398 | 66160604924547 |
2011 | 22266791744888 | 21629681287498 | 73560800068343 |
2012 | 22584261115009 | 21869994165996 | 75163853403288 |
2013 | 23207355481938 | 22462991978893 | 77179982283964 |
2014 | 23492307096837 | 22906967461702 | 79204374257964 |
2015 | 20994754510041 | 20606222830941 | 74791087388432 |
2016 | 20645645142174 | 20098234000669 | 75957380306915 |
2017 | 22721945276253 | 22184626665527 | 80810036157147 |
2018 | 25070788607827 | 24409157015837 | 85946244405253 |
2019 | 24542950333318 | 24065843230229 | 87150243886427 |
2020 | 22104113831346 | 21586105242880 | 84695434787753 |
2021 | 27504490767242 | 26660663580174 | 95874516550488 |