SELECT
YEAR("date") "year",
COUNT (DISTINCT "unnamed_0") "crashes",
SUM(CAST(REGEXP_EXTRACT("fatal", '([0-9]+)') AS INT)) "fatalities"
FROM @kaggle.aryan112345_worst_plane_crashes_in_history.plane_crash_info
GROUP BY "year"
ORDER BY "year"
SELECT
YEAR("date") "year",
COUNT (DISTINCT "unnamed_0") "crashes",
SUM(CAST(REGEXP_EXTRACT("fatal", '([0-9]+)') AS INT)) "fatalities"
FROM @kaggle.aryan112345_worst_plane_crashes_in_history.plane_crash_info
GROUP BY "year"
ORDER BY "year"
Anyone who has the link will be able to view this.