How merge all found reviews in product reviews

SQL++
6

Nice, I want to avg the rating why I get null on rates ?

SELECT p.*, avg(r.rating) as rates
FROM product AS p
NEST reviews AS r
  ON META(r).id in p.reviewList
  Where p.productId ='product20'
  GROUP BY p