Baselight
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"
yearcrashesfatalities
19601134
19661133
19691154
19711163
19723485
19731176
19742537
19752343
19761330
19772714
19782540
19792864
19803613
19811180
19821137
19832450
19841178
198561588
19861167
19873498
19883703
19893662
19912484
19922465
19931133
19942424
19951301
199661279
19972462
19982432
19991217
20003443
200143506
20022374
20032415
20041148
20052303
20062324
20071199
20082307
20093548
20102310
20121159
20143699
20152374
20182446
20191157
20201176
20221132

Share link

Anyone who has the link will be able to view this.