SQL query to pull vulnerability information from a specific asset group

Example name of group is “Global Assets”. Looking to grab Asset Name, IP, CVSS, Exploit count, Vuln title, Vuln Proof, Site, Date last scanned, First found, Vuln age