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-CU3) (KB4538853) - 15.0.4023.6 (X64) Mar 4 2020 00:59:26 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 int)

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, 'E15666',  14

SELECT * FROM @t

select distinct A.week,A.style,A.Color, A.location, A.Actual_size, A.size_code, A.Min_size_code, A.Max_size_code,
min(B.Actual_size) over(partition by A.week,A.style,A.Color,A.location) Min_Actual_Size,
max(B.Actual_size) over(partition by A.week,A.style,A.Color,A.location) Max_Actual_Size
from
(
select week, style, Color, location, Actual_size, size_code,
min(size_code)over(partition by week,style,Color,location) min_size_code,
max(size_code)over(partition by week,style,Color,location) max_size_code
from @t where Style = 'AB123' and color = 'WY4567'
and week = '202002'  and location in ( '111')
) A
Left outer Join 
@t B
on ( A.Style = B.Style and A.Color = B.Color and A.Week = B.Week and A.Location = B.Location)
where (B.size_code = A.min_size_code or B.size_code = A.max_size_code)

style	color	week	location	size_code	actual_size
AB123	WY4567	202002	111	E11222	2
AB123	WY4567	202002	111	E12333	4
AB123	WY4567	202002	111	E13444	6
AB123	WY4567	202002	111	E15666	14

week	style	Color	location	Actual_size	size_code	Min_size_code	Max_size_code	Min_Actual_Size	Max_Actual_Size
202002	AB123	WY4567	111	2	E11222	E11222	E15666	2	14
202002	AB123	WY4567	111	4	E12333	E11222	E15666	2	14
202002	AB123	WY4567	111	6	E13444	E11222	E15666	2	14
202002	AB123	WY4567	111	14	E15666	E11222	E15666	2	14