if函数
select a.partitiontime,if (0<price/100<=20,'0-20',if(20<price/100<=50,'20-50' ,
if(50<price/100<=100,'50-100' ,if(100<price/100<=200,'100-200' , '200+')))),a.from_source,if (a.platform in('android','iPad','iPhone'),'app','qita'), count(distinct a.user_id) from aaa a
where a.partitiontime>='20161005' and a.partitiontime<='20161007'
group by a.partitiontime,if (0<price/100<=20,'0-20',if(20<price/100<=50,'20-50' ,
if(50<price/100<=100,'50-100' ,if(100<price/100<=200,'100-200' , '200+'))))
,a.from_source,if (a.platform in('android','iPad','iPhone'),'app','qita')