Here's an example of a query to show most vulnerable Site by Risk Score per Asset.
You may also find our Risk Scorecard report useful for this type of data.
SELECT ds.name AS site, assets, riskscore,
(CASE riskscore WHEN 0 THEN NULL ELSE riskscore END) / (CASE assets WHEN 0 THEN NULL ELSE assets END) AS "RiskPerAsset"
JOIN dim_site ds USING (site_id)
ORDER BY "RiskPerAsset" DESC
The output shows:
# of assets
Site Risk Score
Risk per Asset