select sum(if(user_id>0, 1, 0)) as reigistered_count from order
select case grade>9 then ‘初中‘ else ‘小学‘ end as grade from student
Mysql中select条件取值写法
原文：https://www.cnblogs.com/august-fz/p/14640527.html
