SELECT PINGTESTURL AS "网站", CAST(MID(TESTRESULT, POSITION("(" IN TESTRESULT) + 1, POSITION(")" IN TESTRESULT) - POSITION("(" IN TESTRESULT) - 1) AS CHAR(20)) AS "IP 地址", AVG(delay) AS "Ping 时延(ms)", COUNT(*) AS "样本数"
FROM APP_PING
GROUP BY `IP 地址`
HAVING COUNT(*) > 5
ORDER BY 网站