SQL query for OWNER tags with trending or total vulns each month

InsightVM SQL Queries
1

@john_hartman
I’m looking for SQL query where it shows the vulnerability trend over time against “OWNER” tag. I’ve trying to figure this out but still failed. The rows should show the asset tag type and the columns shows the trending number of vulnerabilities each month.

sample expectation below

                                      Jan   Feb   Mar
IT Dept                               100   150    200
DevTeam                               200   250   300