我想对我的属性进行评级,以限制用户仅对其进行一次评级。所以我在表中保存了评分点和用户id。
现在我想要这个属性的总平均值
我正在使用我的查询像这样
SELECT SUM(rating_number) as rating_number, FORMAT((SUM(total_points) / SUM(rating_number),1) as average_rating FROM post_rating WHERE post_id = 9781 AND status = 1
但是我得到错误。我怎样才能得到总平均评分。由于
使用
SELECT SUM(rating_number) as rating_number,
FORMAT((SUM(total_points) / SUM(rating_number)),2) as average_rating
FROM post_rating WHERE post_id = 9781 AND status = 1