sqlserver分组后加条件

select * from WagesSalary_Month_User_Rate
 select  
	WW.RateRemake, --- 个人所得税税档
	sum(CASE WHEN WR.Remake is not null THEN 1 ELSE 0 END) as Counts ,---  
	sum(
		CASE WHEN MonthTime = '2019-11' THEN ISNULL(UserMonthWagesSalary_Old_YearCount,0) ELSE 0 END 
	 ),--累计收入额 =至本期年度工资总和
	sum( 
			CASE WHEN MonthTime = '2019-11' THEN ISNULL((Cumulative_Special + Cumulative_Special_add),0) ELSE 0 END 
	) ,--扣减费用（含保险）
	sum(
			CASE WHEN MonthTime = '2019-11' THEN  ISNULL(MonthWagesSalaryRate,0) ELSE 0 END  
	 ),--累计应纳税所得额
	sum( 
		CASE WHEN MonthTime = '2019-11' THEN  ISNULL(WR.WithholdingSalary ,0) ELSE 0 END  
	),--as 速算扣除数  
	sum( ISNULL(DeductionValue,0))--  应补（退）税款 = 工资表应纳税额
 from WagesSalary_Month_User_Rate WR    
	-- inner join SalaryBaseInfo base on WR.UserShowId = base.Id 
	 right join WagesSalary_Withholding_Rate WW on WW.RateRemake = WR.RateRemake  
	
	 group by WW.RateR