Enhancing a Dashboard Card With a SQL query

Currently the Average Days to Remediate By CVSSv3 Severity Ratings card provides only the last 6 months of information. I would like to have a SQL query that provides the same info but for the past 12 month and also have an average remediation for the whole 12 months. I’m not very familiar with SQL queries, I usually get my inspiration from the Github Repo but non seem to give me exactly what I would need. Can anyone be of assistance?

This request has been fairly common. Personally, I haven’t been able to produce (after many attempts…) a pratical SQL query that provides this information.

Thanks, I did see your responses concerning the Datawarehouse which could make it possible…unfortunately we don’t have one. Thanks for the info