Best solution per vulnerability

InsightVM SQL Queries
1

I’m looking for an SQL query to get a list of the best solution per vulnerability

2

Here is the the query.

SELECT DISTINCT
   da.host_name AS "Hostname",
   dos.description AS "Operating System",
   round(dv.riskscore :: numeric, 0) AS "Risk",
   round(dv.cvss_score :: numeric, 2) AS "CVSS Score",
   proofAsText(dv.description) AS "Vulnerability Details",
   fasvf.vulnerability_instances AS "Vulnerability Count on Asset",
   fava.most_recently_discovered AS "Date Most Recently Seen on Asset",
   proofAsText(ds.fix) AS "Best Solution",
   proofAsText(ds.solution_type) AS "Solution Type"
FROM dim_asset da
JOIN dim_operating_system dos ON dos.operating_system_id = da.operating_system_id
JOIN dim_asset_vulnerability_best_solution davbs ON davbs.asset_id = da.asset_id
JOIN dim_solution ds ON ds.solution_id = davbs.solution_id
JOIN dim_vulnerability dv ON dv.vulnerability_id = davbs.vulnerability_id