SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[Printer](
	[code] [int] NOT NULL,
	[model] [varchar](50) NOT NULL,
	[color] [char](1) NOT NULL,
	[type] [varchar](10) NOT NULL,
	[price] [money] NULL,

) 
INSERT INTO [dbo].[Printer]
           ([code]
           ,[model]
           ,[color]
           ,[type]
           ,[price])
     VALUES
           (1 
           ,'1276' 
           ,'n'
           ,'Laser'
           ,400 )


,(2 
           ,'1433' 
           ,'y'
           ,'Jet'
           ,270 )
,(3 
           ,'1434' 
           ,'y'
           ,'Jet'
           ,290 )
           
           
           ,(4 
           ,'1401' 
           ,'n'
           ,'Matrix'
           ,150 )
           
                ,(5 
           ,'1408' 
           ,'n'
           ,'Matrix'
           ,270 )
           
                ,(6 
           ,'1288' 
           ,'n'
           ,'Laser'
           ,400 )

6 rows affected

select * from printer


code
model
color
type
price


1
1276
n
Laser
400.0000

2
1433
y
Jet
270.0000

3
1434
y
Jet
290.0000

4
1401
n
Matrix
150.0000

5
1408
n
Matrix
270.0000

6
1288
n
Laser
400.0000


select *,
       avg(price) over(partition by grp) avg_price,
       sum(is_new) over(partition by grp) distinct_type_cnt
  from (
    select *,
         case when lag(type,1,'') over(partition by grp order by type) != type then 1 else 0 end is_new
      from (
        select *, sum(case color when 'n' then 1 end) over (order by code) as grp
          from printer
      ) x
  ) y
order by code


code
model
color
type
price
grp
is_new
avg_price
distinct_type_cnt


1
1276
n
Laser
400.0000
1
1
320.0000
2

2
1433
y
Jet
270.0000
1
1
320.0000
2

3
1434
y
Jet
290.0000
1
0
320.0000
2

4
1401
n
Matrix
150.0000
2
1
150.0000
1

5
1408
n
Matrix
270.0000
3
1
270.0000
1

6
1288
n
Laser
400.0000
4
1
400.0000
1


Warning: Null value is eliminated by an aggregate or other SET operation.

code	model	color	type	price
1	1276	n	Laser	400.0000
2	1433	y	Jet	270.0000
3	1434	y	Jet	290.0000
4	1401	n	Matrix	150.0000
5	1408	n	Matrix	270.0000
6	1288	n	Laser	400.0000