SELECT	YM, ParentID, GMV,
		case when GMV=0 and  then 1 end Churn 
FROM 
	(
	select	YM, ParentID, sum(GMV) GMV
	from	(
			select  YM, ParentID, GMV
			from DP_GMV_Forecast.test
			where ParentID=35535000 and GMV=0
			) t1
	group by YM, ParentID
	) t2