mysql - 除以零进行排序过程

Question

嗨，我的数据库中有两个表:用户和评级。我需要按评分对它们进行排序:

SELECT * 
FROM users
LEFT JOIN ratings ON users.id = ratings.id
ORDER BY ratings.total_value / ratings.total_votes DESC 
LIMIT 0 , 30

有时total_value值为空，我是否应该添加额外的条件来检查这些值是否为空？

Answer 1

我认为COALESCE()将在这里工作:

ORDER BY COALESCE(ratings.total_value, 0) / ratings.total_votes DESC