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"]