'how to count all records that are repeated more than 5 times in a date

I am trying to obtain in a single record grouped by user the total sum of the records that are repeated more than 5 times on a date

This is my query

select user_id, answer_date, count(*) as total_mayor_que_5
from items
WHERE items.proyecto_id = 6
  and `estado` IN (1,4)
  AND `liquidada` = 1
  and items.answer_date BETWEEN '2021-01-01' and '2021-12-31'
  and items.user_id = 832
GROUP BY user_id, answer_date
HAVING COUNT(answer_date) >= 5

and as result have this

user_id answered_date more_greater_than_5
832 2021-11-08 6
832 2021-11-09 6
833 2021-11-09 6
833 2021-11-09 5

I don't want it to show me all those records; instead, I want a total. For example, for the user with id 832, the total would be 12.

This is my structure table items

db structure

I want something like this

user_id total
832 12
833 11

Can somebody help me? Thanks



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source