---

Select(
    Host.OsName as "ОС",
    count(*) as "Количество"
)
| Group("ОС", count(*) as "Количество")
| Join(
    Select(count(*) as "Всего") as T,
    true
)
| Calc(
    round("Количество" * 100.0 / T."Всего", 2) as "Процент"
)
| Sort("Количество" desc)


Select(
    Host.OsName as os
)
| Calc(
    if os contains "Windows" then "Windows"
    else if os contains "Linux" then "Linux"
    else if os contains "Unix" then "Unix"
    else if os then os
    else "Unknown"
    as "ОС"
)
| Group("ОС", count(*) as "Количество")
| Join(
    Select(count(*) as "Всего") as T,
    true
)
| Calc(
    round("Количество" * 100.0 / T."Всего", 2) as "Процент"
)
| Sort("Количество" desc)