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