mysql 排序时对Null值的处理

数据表tb_score:

想实现的效果是：为null值的score在最上面，score要逆序排列

mysql思路：需要用到case when的思路

SELECT
	*,
CASE
		
		WHEN score IS NULL THEN
		1 ELSE 0 
	END AS new_order 
FROM
	tb_score 
ORDER BY
	new_order DESC,
	score DESC