SELECT f.supplier_id, AVG(f.price)
OVER(PARTITION BY f.supplier_id) avg_price
FROM food f
INNER JOIN supplier s ON f.supplier_id = s.id
ORDER BY s.fullname;