1SELECT 
2  YEAR("date") "year", 
3  COUNT (DISTINCT "unnamed_0") "crashes", 
4  SUM(CAST(REGEXP_EXTRACT("fatal", '([0-9]+)') AS INT)) "fatalities"
5FROM @kaggle.aryan112345_worst_plane_crashes_in_history.plane_crash_info
6GROUP BY "year"
7ORDER BY "year"