101

SELECT code, model, color, type, price,
	MAX(model) OVER(PARTITION BY partition ORDER BY code ASC),
	AVG(price) OVER(PARTITION BY partition ORDER BY code ASC)
FROM
(
	SELECT *,
	CASE
		WHEN color = 'n'
			THEN 1
		ELSE 0
	END AS partition
	FROM printer
) t
ORDER BY code ASC