SELECT 
               supplier_order_items.product_id,
               extract(YEAR FROM supplier_orders.time)  AS year,
               max(supplier_order_items.price_per_item) AS price_per_item
                                                         
FROM supplier_order_items
                                                                 
INNER JOIN supplier_orders ON supplier_order_items.order_id = supplier_orders.id
            
            
GROUP BY 1, 2
            
HAVING extract(YEAR FROM supplier_orders.time) = ?
            
ORDER BY supplier_order_items.product_id ASC