query error!

전체브랜드

query error! select Brand=max(Brand), BrandID,ViewYes=max(ViewYes),BestYes=max(BestYes),Cnt=sum(Cnt), BrandKor= max(BrandKor) from psBrandMainBatch where ViewYes=1 and Rcnt >= 1 group by BrandID order by BrandID
select Brand=max(Brand), BrandID,ViewYes=max(ViewYes),BestYes=max(BestYes),Cnt=sum(Cnt), BrandKor= max(BrandKor) from psBrandMainBatch where ViewYes=1 and Rcnt >= 1 group by BrandID order by BrandID
select Brand=max(Brand), BrandID,ViewYes=max(ViewYes),BestYes=max(BestYes),Cnt=sum(Cnt), BrandKor= max(BrandKor) from psBrandMainBatch where ViewYes=1 and Rcnt >= 1 group by BrandID order by BrandID
V