1、例:计算f表中money值的和,并赋予别名(where条件:change_type=2)
field('sum(if(f.change_type=2,f.money,0)) as consume_money')
2、例:统计s表有多少条数据,并赋予别名(where条件:status=1 and audit_status=1)
field('COUNT(IF(s.status=1 and s.audit_status=1,s.id,null)) as a')
3、判断selfad_id是不是null,是null返回0,不是返回selfad_id的值
field('ifnull(dcp.selfad_id,0) as ad_play')