SQL query to report on Asset Groups


I’m completely new to SQL. Would someone be able to help me we writing a SQL query so I can report on the following:

For each Asset Group in a list specified in the SQL query itself, return count of unique devices and a summary count of vulnerabilities based on CVSS score severity (Critical, High, Medium, Low, None)

Thank you in advance for any help!


This might be a good place to start