1SELECT EXTRACT(year FROM "date") as "year", avg("close")
2FROM @kaggle.benjaminpo_s_and_p_500_with_dividends_and_splits_daily_updated.near_usd
3GROUP BY EXTRACT(year FROM "date")
4ORDER BY EXTRACT(year FROM "date")