mysql case when 用法举例

举例：

select customer_id,user_id,
    case when count(1)  >=50 then 50
	     when count(1)  >=40 then 40
		 when count(1)  >=30 then 30
		 when count(1)  >=20 then 20
		 when count(1)  >=10 then 10
		 else 0 END score
	from chat_records 
	where  is_send = 0 
    group by customer_id,user_id