Loading...Loading chart...
1SELECT
2 year,
3 AVG(military_expenditure_of_gdp) AS average_military_expenditure_of_gdp,
4 SUM(military_expenditure_current_usd) AS total_military_expenditure_current_usd
5FROM
6 "@kaggle.prasertk_military_expenditure_by_country_from_19702020.military_expenditure"
7GROUP BY
8 year
9ORDER BY
10 year;