1SELECT
2  year,
3  SUM(
4    CASE
5      WHEN offense_name = 'Violent Crime' THEN actual
6    END
7  ) AS violent_crime_total,
8  SUM(
9    CASE
10      WHEN offense_name = 'Property Crime' THEN actual
11    END
12  ) AS property_crime_total
13FROM
14  "@fbi.fbi_crime_summarized.crime_data_state"
15WHERE
16  state = 'MN'
17  AND year IN (2023, 2024, 2025)
18  AND metric_type = 'Offenses'
19  AND offense_name IN ('Violent Crime', 'Property Crime')
20  AND month IS NOT NULL
21GROUP BY
22  year
23ORDER BY
24  year ASC