mysql - MySQL group by 查询出错

Question

我正在使用以下形式的 SQL 查询

   create table tb5
   SELECT count(*) as count, question, responsesummary, questionid from tb4 
   where responsesummary!= rightanswer group by  question,responsesummary 

我得到的结果如下

        count                 question             responsesummary     id
         5                      q1                     abc            331
         6                      q1                     def            331
         5                      q1                     abc            331

相反，我想要

       count                 question             responsesummary      id 
         10                      q1                     abc           331
         6                      q1                     def             331

我做错了什么？是否可以向现有结果添加新查询并获得所需的输出？

Answer 1

SELECT 
      COUNT(*) as count, 
      question, 
      responsesummary,
      question_id
FROM tb5
WHERE responsesummary!= rightanswer GROUP BY responsesummary,question_id,question