#!/bin/bash

grep -Eo "\:.+3306.*ESTA" "./nowcoder.txt" | grep -Eo "[0-7]+\..+\..+\.[0-7]+" | awk '{list[$0]++} END{for(i in list){print list[i] " " i;}}' | sort -n -r -k1

愚蠢但易懂