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 |