mysql - 以下语句出现多少次SQL

Question

我想找出系统结果 no_answer 超过 5 次的每个不同数字

有谁知道如何找到以下内容，即

Table Name Calls

Field 1 - Phone_number
Field 2 - System_outcome

Phone_number      System_outcome
07777778999       Answered
07777778123       No Answer
07777778999       No Answer
07777778999       No Answer
07777778999       No Answer
07777778999       No Answer
07777778124       No Answer
07777778128       Answered
07777778074       Answered

Answer 1

SELECT Phone_number, COUNT(*) AS no_answer_count
FROM Calls
WHERE System_outcome = 'no_answer'
GROUP BY Phone_number
HAVING no_answer_count > 5