Loading...Loading chart...
1SELECT strftime(time, '%Y-%m') AS year_month, max(mag) as peak_magnitude, count(id) as nr_earthquakes
2FROM @pjsousa.sandbox.earthquakes_since_2023_csv a
3GROUP BY year_month
4order by 11SELECT strftime(time, '%Y-%m') AS year_month, max(mag) as peak_magnitude, count(id) as nr_earthquakes
2FROM @pjsousa.sandbox.earthquakes_since_2023_csv a
3GROUP BY year_month
4order by 1Anyone who has the link will be able to view this.