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.