coalesce()

使用count()函数时需要注意

SELECT count(DISTINCT COALESCE(user_name, 'NULL')) AS num FROM t_user;