1.case语法
CASE case_value
WHEN when_value THEN statement_list
[WHEN when_value THEN statement_list] …
[ELSE statement_list]
END CASE
select CASE age when age>30 then 'boy' ELSE 'girl' end as sex from people
2.IF
(expr1,expr2,expr3)
expr1条件为真,返回expr2,否则返回expr3
3.count()加条件,统计大于20的