1SELECT
2  year,
3  SUM(actual) AS total_crimes
4FROM
5  "@fbi.fbi_crime_summarized.crime_data_state"
6WHERE
7  metric_type = 'Offenses'
8  AND year >= 1985
9  AND year <= 2025
10GROUP BY
11  year
12ORDER BY
13  year ASC