SQL Server 2017

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

CREATE TABLE Products (
[name] nvarchar(50),
[size] smallint,
[cat] nvarchar(50),
[cond] nvarchar(50),
[created] datetime not null default getdate()
);

CREATE TABLE SizeRanges1 (
LimL1 smallint,
LimU1 smallint,
Description1 nvarchar(20)
);

CREATE TABLE SizeRanges2 (
LimL2 smallint,
LimU2 smallint,
Description2 nvarchar(40)
);

insert into Products(name, size, cat, cond) values(N'Product1', 20,  N'Phone1', N'OK');
insert into Products(name, size, cat, cond) values(N'Product1', 20,  N'Phone1', N'OK');
insert into Products(name, size, cat, cond) values(N'Product1', 20,  N'Phone1', N'OK');
insert into Products(name, size, cat, cond) values(N'Product2', 400, N'Note2', N'OKOK' );
insert into Products(name, size, cat, cond) values(N'Product3', 255, N'Note', N'OK');
insert into Products(name, size, cat, cond) values(N'Product4', 385, N'Note', N'OK');
insert into Products(name, size, cat, cond) values(N'Product5', 420, N'Note', N'SOSO');
insert into Products(name, size, cat, cond) values(N'Product5', 420, N'Note', N'OK');
insert into Products(name, size, cat, cond) values(N'Product7', 8800, N'No', N'OK');

insert into SizeRanges1(limL1, LimU1, Description1) values (0, 25, N'Малый');
insert into SizeRanges1(limL1, LimU1, Description1) values (26, 100, N'Маленький');
insert into SizeRanges1(limL1, LimU1, Description1) values (405, 418, N'Средний');
insert into SizeRanges1(limL1, LimU1, Description1) values (600, 700, N'Большой');

insert into SizeRanges2(limL2, LimU2, Description2) values (200, 280, N'Элька');
insert into SizeRanges2(limL2, LimU2, Description2) values (300, 500, N'Эмка');
insert into SizeRanges2(limL2, LimU2, Description2) values (1000, 5000, N'Офигенный');

SELECT * FROM Products;
SELECT * FROM SizeRanges1;
SELECT * FROM SizeRanges2;

name	size	cat	cond	created
Product1	20	Phone1	OK	2022-02-15 16:43:41.657
Product1	20	Phone1	OK	2022-02-15 16:43:41.657
Product1	20	Phone1	OK	2022-02-15 16:43:41.657
Product2	400	Note2	OKOK	2022-02-15 16:43:41.657
Product3	255	Note	OK	2022-02-15 16:43:41.657
Product4	385	Note	OK	2022-02-15 16:43:41.657
Product5	420	Note	SOSO	2022-02-15 16:43:41.657
Product5	420	Note	OK	2022-02-15 16:43:41.657
Product7	8800	No	OK	2022-02-15 16:43:41.657

LimL1	LimU1	Description1
0	25	Малый
26	100	Маленький
405	418	Средний
600	700	Большой

LimL2	LimU2	Description2
200	280	Элька
300	500	Эмка
1000	5000	Офигенный

name	size	cat	cond	created	Description
Product1	20	Phone1	OK	2022-02-15 16:43:41.657	Малый
Product2	400	Note2	OKOK	2022-02-15 16:43:41.657	Эмка
Product3	255	Note	OK	2022-02-15 16:43:41.657	Элька
Product4	385	Note	OK	2022-02-15 16:43:41.657	Эмка
Product5	420	Note	OK	2022-02-15 16:43:41.657	Эмка
Product5	420	Note	SOSO	2022-02-15 16:43:41.657	Эмка
Product7	8800	No	OK	2022-02-15 16:43:41.657	XYZ