以下是我的tblReviewRating
数据表():
rrFood rrService rrCleanliness rrAmbience rrBqtID rrCusID
------ --------- ------------- ---------- ------- -------
3 4 2 1 1 1
5 4 3 2 1 2
4 2 4 2 2 5
4 2 4 2 2 7
4 2 4 2 2 9
我正在尝试计算rrBqtID
来自客户(rrCusID
)的每个单独宴会厅()的前四列(在5个标度中)的平均值:
SELECT rrFood,rrService,rrCleanliness,rrAmbience,
ROUND(AVG(rrFood+rrService+rrCleanliness+rrAmbience),2) AS AverageRating
FROM tblReviewRating
GROUP BY rrFood,rrService,rrCleanliness,rrAmbience
我该如何计算四种服务的平均评分以及AverageRating
他们的客户提供的每个宴会厅的平均评分?
编辑:我想在我的查询中应用此示例来计算评分。
如果您想要rrBqtID,rrCusID的平均值,则应按rrFood,rrService,rrCleanliness,rrAmbience分组,但对于rrBqtID,rrCusID
SELECT rrBqtID, rrCusID,
ROUND(AVG(rrFood+rrService+rrCleanliness+rrAmbience),2) AS AverageRating
FROM tblReviewRating
GROUP BY rrBqtID, rrCusID
如果您想查看其他信息附近的平均值,则应使用join。
SELECT A.rrFood,A.rrService,A.rrCleanliness,A.rrAmbience , T.AverageRating
FROM tblReviewRating A
INNER JOIN (
SELECT rrBqtID, rrCusID,
ROUND(AVG(rrFood+rrService+rrCleanliness+rrAmbience),2) AS AverageRating
FROM tblReviewRating
GROUP BY rrBqtID, rrCusID
) T ON T.rrBqtID = A.rrBqtID and T.rrCusID = A.rrCusID
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句