---

Select(
    @Host,
    Host.@Vulners as v,
    Host.@Vulners.Status as "Статус",
    Host.@Vulners.Score as "Рейтинг"
)
| Filter(v and "Статус" = "New")
| Join(
    Select(@Host, compact(Host.@Groups) as "Группа") as G,
    @Host = G.@Host
)
| Group(G."Группа", "Рейтинг", count(*) as "Количество")
| Sort("Количество" desc)