select product, avg(sales)
from Order
group by product

"Error: could not identify an equality operator for type json"

--Order--
id | sales | product
1  | 36    | ["874746", "474657"]
2  | 120   | ["874748"]
3  | 15    | ["874736", "474654"]