By clause can group by clause by clause! Claim Direct
In by count where & Is no means to mysql group count clause in where