Код: Выделить всё
WowVersion | count
------------+-------
7.2.5 | 1
6.2.3 | 1
8.0.1 | 1
4.3 | 4
1.13.3 | 6
3.3 | 11
pirate | 16
7.3.5 | 19
8.2.0 | 22
8.3.0 | 48
select "WowVersion", count(*) from "User" join (select distinct "WowVersion", "UserId" from "Build" where "WowVersion" is not null) as t ON t."UserId" = "User"."UserId" group by "WowVersion" order by count(*);