Бот World of Warcraft

Код: Выделить всё

 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(*);