1SELECT 
2  EXTRACT(YEAR FROM STRPTIME("date", '%B %-d, %Y')) "year", 
3  COUNT(*) "crashes",
4  SUM(CAST(NULLIF(REGEXP_EXTRACT("fatalities", '([0-9]+).*', 1), '') AS INT)) "fatalities"
5FROM @kaggle.luiscfrancisco_plane_crashes_dataset.accident_details_compiled
6GROUP BY "year"
7HAVING "year" < 2024
8ORDER BY "year" ASC