Baselight
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;
yearaverage_military_expenditure_of_gdptotal_military_expenditure_current_usd
19703.5024171373086115692597766177.802
19713.446407337274166698372917268.605
19723.430922755384381759846048731.0715
19733.3546702414891034846152897371.6755
19743.3888903635792498981897423409.7585
19753.76389814593035951099916993685.9084
19763.7516330229360131154222048455.9119
19773.790112851108831348984022533.4973
19783.83407266949653061497775017051.2595
19793.54179567392331671661553939111.7732
19803.49646244750284562267201829597.1523
19813.6621820195933812481648571622.781
19823.9208118321845822287104849479.723
19833.82038579173723972258369144457.108
19843.6924452580350192808613505112.362
19853.6857970128957982964155896526.4956
19863.5029249442565733247525934902.4365
19873.69724398614195953665004567910.9604
19883.65409632866395433867986226357.649
19893.37481951945709654442927682268.683
19903.52149799402725844809645942636.177
19913.92127886259386974697099285232.804
19923.16405783512851674916188128755.863
19933.0182643918053274904505876371.927
19942.8378644137502375015638374977.073
19952.56996835278242755203363189355.665
19962.4764014894786125244402955966.609
19972.49360416224502935256725263730.637
19982.6314758969687645118769737281.547
19992.64308216477385835215255084056.068
20002.4206912756095155370855599686.793
20012.35670440208822775483372552536.271
20022.31616098063969175884328506324.998
20032.2202201118099376939319457546.822
20042.07126938780744537884207950089.174
20051.96850836147658088553912734830.845
20061.93789845560167458758743852698.125
20071.95895801510197439849138193612.344
20081.93652400755630311251801030253.08
20092.087102130700401411636269052878.799
20101.939443995378746612313227891646.021
20111.85644368407822113206992644813.736
20121.88868038801688613427143594315.424
20131.937740285626466313633878408661.834
20142.012139578846797513700467237991.062
20151.97246822903911812911600522692.492
20161.935616456275913712907160424026.975
20171.87915068484737813519979731585.57
20181.824545868720682614125790084824.49
20191.844572933492139714559184232642.225
20201.991459485252579515023346935792.54

Share link

Anyone who has the link will be able to view this.