我需要帮助才能找到所有更好产品的平均评级[暂停]

提问于 2024-04-29T02:55:32+08:00

浏览次

-1

id  year category_id    rating  avg_better

需要帮助找到所有更好的产品的平均评级

1 回答

0

select *,
 ( select avg(rating) 
   from mytab as t2
   where t2.year = t1.year     -- same year
     and t2.rating > t1.rating -- better rating
 ) as avg_better
from mytab as t1

回复于 2024-04-29T02:55:32+08:00

相关问题