SQL Server 2019

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

(No column name)
Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) Jul 25 2020 11:26:55 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

declare @t table (style varchar(100), color varchar(100), [week] int, [location] int, size_code varchar(10), actual_size varchar(10))

insert into @t select 'AB123', 'WY4567', 202002, 111, 'E11222',  '2' 
insert into @t select 'AB123', 'WY4567', 202002, 111, 'E12333',  '4' 
insert into @t select 'AB123', 'WY4567', 202002, 111, 'E13444',  '6' 
insert into @t select 'AB123', 'WY4567', 202002, 111, 'E10666',  '14'
insert into @t select 'AB123', 'WY4567', 202002, 111, 'E15666',  '00'
insert into @t select 'AB123', 'WY4567', 202002, 111, 'E11666',  '0'

insert into @t select 'XY123', 'WY4567', 202002, 111, 'E11666',  '1'
insert into @t select 'XY123', 'WY4567', 202002, 111, 'E13444',  '2'
insert into @t select 'XY123', 'WY4567', 202002, 111, 'E12666',  '0'

;with cte as
(
	select *
	, ROW_NUMBER() over (partition by A.[week],A.style,A.Color,A.[location] order by case when convert(int, actual_size) = 0 then cast(cos(replace(actual_size, '0', '1')) as float) else cast((actual_size) as float) end) rn_min
	, ROW_NUMBER() over (partition by A.[week],A.style,A.Color,A.[location] order by case when convert(int, actual_size) = 0 then actual_size else -1*actual_size end) rn_max
	, max(convert(int, actual_size)) over (partition by style, [week], color, [location]) as max_actual_size
	from @t A
)
select t1.style, t1.color, t1.[week], t1.[location], t1.size_code, t1.actual_size
, min(t3.size_code) over (partition by t1.[week],t1.style,t1.Color,t1.[location]) min_size_code
, max(t2.size_code) over (partition by t1.[week],t1.style,t1.Color,t1.[location]) max_size_code
,min(t3.actual_size) over (partition by t1.[week],t1.style,t1.Color,t1.[location]) min_actual_size
,t1.max_actual_size
from cte t1
left join cte t2
on t1.style = t2.style and t1.color = t2.color and t1.[week] = t2.[week] and t1.[location] = t2.[location] and t1.actual_size = t2.max_actual_size and t2.rn_max = 1
left join cte t3
on t1.style = t3.style and t1.color = t3.color and t1.[week] = t3.[week] and t1.[location] = t3.[location] and t1.actual_size = t3.max_actual_size and t3.rn_min = 1

style	color	week	location	size_code	actual_size	min_size_code	max_size_code	min_actual_size	max_actual_size
AB123	WY4567	202002	111	E11222	2	E15666	E10666	00	14
AB123	WY4567	202002	111	E12333	4	E15666	E10666	00	14
AB123	WY4567	202002	111	E13444	6	E15666	E10666	00	14
AB123	WY4567	202002	111	E10666	14	E15666	E10666	00	14
AB123	WY4567	202002	111	E15666	00	E15666	E10666	00	14
AB123	WY4567	202002	111	E11666	0	E15666	E10666	00	14
XY123	WY4567	202002	111	E11666	1	E12666	E13444	0	2
XY123	WY4567	202002	111	E13444	2	E12666	E13444	0	2
XY123	WY4567	202002	111	E12666	0	E12666	E13444	0	2

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