SELECT
year,
AVG(military_expenditure_of_gdp) AS average_military_expenditure_of_gdp,
SUM(military_expenditure_current_usd) AS total_military_expenditure_current_usd
FROM
"@kaggle.prasertk_military_expenditure_by_country_from_19702020.military_expenditure"
GROUP BY
year
ORDER BY
year;
year | average_military_expenditure_of_gdp | total_military_expenditure_current_usd |
---|---|---|
1970 | 3.5024171373086115 | 692597766177.802 |
1971 | 3.446407337274166 | 698372917268.605 |
1972 | 3.430922755384381 | 759846048731.0715 |
1973 | 3.3546702414891034 | 846152897371.6755 |
1974 | 3.3888903635792498 | 981897423409.7585 |
1975 | 3.7638981459303595 | 1099916993685.9084 |
1976 | 3.751633022936013 | 1154222048455.9119 |
1977 | 3.79011285110883 | 1348984022533.4973 |
1978 | 3.8340726694965306 | 1497775017051.2595 |
1979 | 3.5417956739233167 | 1661553939111.7732 |
1980 | 3.4964624475028456 | 2267201829597.1523 |
1981 | 3.662182019593381 | 2481648571622.781 |
1982 | 3.920811832184582 | 2287104849479.723 |
1983 | 3.8203857917372397 | 2258369144457.108 |
1984 | 3.692445258035019 | 2808613505112.362 |
1985 | 3.685797012895798 | 2964155896526.4956 |
1986 | 3.502924944256573 | 3247525934902.4365 |
1987 | 3.6972439861419595 | 3665004567910.9604 |
1988 | 3.6540963286639543 | 3867986226357.649 |
1989 | 3.3748195194570965 | 4442927682268.683 |
1990 | 3.5214979940272584 | 4809645942636.177 |
1991 | 3.9212788625938697 | 4697099285232.804 |
1992 | 3.1640578351285167 | 4916188128755.863 |
1993 | 3.018264391805327 | 4904505876371.927 |
1994 | 2.837864413750237 | 5015638374977.073 |
1995 | 2.5699683527824275 | 5203363189355.665 |
1996 | 2.476401489478612 | 5244402955966.609 |
1997 | 2.4936041622450293 | 5256725263730.637 |
1998 | 2.631475896968764 | 5118769737281.547 |
1999 | 2.6430821647738583 | 5215255084056.068 |
2000 | 2.420691275609515 | 5370855599686.793 |
2001 | 2.3567044020882277 | 5483372552536.271 |
2002 | 2.3161609806396917 | 5884328506324.998 |
2003 | 2.220220111809937 | 6939319457546.822 |
2004 | 2.0712693878074453 | 7884207950089.174 |
2005 | 1.9685083614765808 | 8553912734830.845 |
2006 | 1.9378984556016745 | 8758743852698.125 |
2007 | 1.9589580151019743 | 9849138193612.344 |
2008 | 1.936524007556303 | 11251801030253.08 |
2009 | 2.0871021307004014 | 11636269052878.799 |
2010 | 1.9394439953787466 | 12313227891646.021 |
2011 | 1.856443684078221 | 13206992644813.736 |
2012 | 1.888680388016886 | 13427143594315.424 |
2013 | 1.9377402856264663 | 13633878408661.834 |
2014 | 2.0121395788467975 | 13700467237991.062 |
2015 | 1.972468229039118 | 12911600522692.492 |
2016 | 1.9356164562759137 | 12907160424026.975 |
2017 | 1.879150684847378 | 13519979731585.57 |
2018 | 1.8245458687206826 | 14125790084824.49 |
2019 | 1.8445729334921397 | 14559184232642.225 |
2020 | 1.9914594852525795 | 15023346935792.54 |