Mysql – How to divide COUNT by 6

MySQL

So, probably spelled my question wrong, anyway.
I'm trying to run a test scenario where some values are duplicated, so they should be 6 but if duplicated they are 12 or 18 and so on,

Currently I'm finding them by
having COUNT(*) > 6

but I also want to make sure that the return result would be only those that can be divided by 6 , like 12/6, 18/6 would be returned, but something like 15/6 would not, so I suppose its 'whole' numbers – integer.

select rr.review_id
from review_rating rr
inner join review rw on 
rr.review_id = rw.id
group by review_id
having COUNT(*) > 6 

So, I only want to filter the results whose count can be divided by 6 and the result would be an integer/whole number.

Best Answer

select rr.review_id
from review_rating rr
inner join review rw on rr.review_id = rw.id
group by review_id
having MOD(COUNT(*),6)=0