SELECT num,总数, ROUND(b."总数"*1.00/393,10) as 百分比 from (SELECT num,COUNT(num) as 总数 FROM "kai" GROUP BY num) b ORDER BY 百分比 desc
14 39 0.0992366412
12 38 0.096692112
11 33 0.0839694656
13 31 0.0788804071
15 30 0.0763358779
17 23 0.058524173
19 23 0.058524173
16 22 0.0559796438
8 21 0.0534351145
10 20 0.0508905852
18 19 0.048346056
20 17 0.0432569975
9 14 0.0356234097
7 13 0.0330788804
21 12 0.0305343511
4 7 0.0178117048
5 5 0.0127226463
6 5 0.0127226463
22 5 0.0127226463
23 5 0.0127226463
25 4 0.010178117
2 2 0.0050890585
24 2 0.0050890585
3 1 0.0025445293
26 1 0.0025445293
27 1 0.0025445293