>>You're looking at COUNT DISTINCT (*)
>
>I never like DISTINCT. I found OVER. So far, it provides the same result.
I see, that's a weird query. I am not even sure how it works. COUNT(*) OVER() is supposed to count all rows. Then you GROUP BY.
If it's not broken, fix it until it is.
My Blog