[步骤]
db.SalesForecastInfo.find({"OrderSourceSku" : "F0330D9C4M39I6D"}).projection({})
.sort({_id:-1})
.limit(100)
SELECT
SUM( c.rating_star * ( CASE WHEN c.comment_count IS NULL AND c.rating_star > 0 THEN 1 ELSE c.comment_count END ) ) / SUM( CASE WHEN c.comment_count IS NULL AND c.rating_star > 0 THEN 1 ELSE c.comment_count END ) AS '加权平均星级',
SUM(CASE WHEN c.comment_count IS NULL AND c.rating_star > 0 THEN 1 ELSE c.comment_count END) AS '总评论数'
FROM
t_amazon_listing_extra_parent_asin c
WHERE
c.asin IN ('B0DSGL646N', 'B0DSGL6J18', 'B0F1DZF3MC', 'B0DSGL2M3T', 'B0DQK3TY3X', 'B0DTJ93GFL', 'B0F22J3D2F', 'B0DXFYS5LM', 'B0DTJ6RDHB', 'B0DSGMZ4X2', 'B0DTJ6Y4RW', 'B0DSGL417T', 'B0DSGMWZG9', 'B0DK22SXBW', 'B0DSGMTFW7', 'B0DSGL31D6', 'B0DQLLCNJW', 'B0DJYRGSFX', 'B0DJZWCMYH', 'B0DTJ6N2NL', 'B0DJYRW8BY', 'B0DVSL5ZJ5', 'B0DVSJFCN5', 'B0DSGMNYZ2', 'B0DM2N4CDG', 'B0DRTQ28NB', 'B0DSGL19MP', 'B0DM2HCZMX', 'B0DJYPDL5M', 'B0DYTV39DM', 'B0DTV48WRQ', 'B0DVSHKTDV', 'B0DQL961B7', 'B0DSGL93KG', 'B0DSGJ9JC5', 'B0DVSJ8FBM', 'B0F22JW456', 'B0DSGMV2LP', 'B0DVSKN7W6', 'B0DJYS4H43', 'B0DXMXS3YJ', 'B0DP895PBX', 'B0DV5QNCRR', 'B0DV5R98J4', 'B0DML2S7RQ', 'B0DJYRYJMF', 'B0DVSN7CLN', 'B0DM5QWWWC')
[结果]
[期望]
调用公式： 5 + 2.5 * (star - 3) =10，