#!/bin/bash

awk '{print $5}' nowcoder.txt|grep "3306"|awk -F ':' '{print $1}'|sort|uniq -c|sort -nr|awk '{print $1,$2}'