$ zcat qwe.gz | awk '{a[$7]+=1} END{for (i in a) print a[i] " ==> " i}' | sort -rn | head -20

$ cat part01.txt | awk '{a[$1]+=1} END{for (i in a) print a[i] " ==> " i}' | sort -rn | head -20

$ cat part01 |grep Windows| awk '{a[$1]+=1} END{for (i in a) print a[i] " ==> " i}' | sort -rn | head -20

$ cat install.banban.im.cn.log |awk '{if ($10!=20000) {a[$10]++;s=NR}} END {for (i in a) {print a[i],i,a[i]/s*100 "%"}}'|sort -rn

$ cat 14.215.165.50.log |awk -F '\t' '{if ($8!~/20000/) {a[$8]++}} END {for (i in a) {print a[i],i,a[i]/NR*100 "%"}}'|sort -rn