SQL Server 2014

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

DECLARE @PRODUCTS TABLE (NAME varchar(100), SIZE varchar(15));

INSERT @PRODUCTS (NAME, SIZE) VALUES

('Nike Activate ST', 'XS'),

('Adidas Outrun XLR2', 'M'),

('Puma Freetrack', '34 2/3'),

('Under Armour Comfort Socks', '4-6'),

('Adidas Euroleague Ball', 'Size three'),

('Puma Freetrack', '32'),

('Adidas Euroleague Ball', 'Size five'),

('Fila Valira Velcro Kids', '22'),

('Nike Activate ST', 'M'),

('Nike Activate ST', 'L'),

('Fila Valira Velcro Kids', '24 2/3'),

('Fila Valira Velcro Kids', '24.5'),

('Fila Valira Velcro Kids', '24 1/2'),

('Fila Valira Velcro Kids', '24 1/3'),

('Fila Valira Velcro Kids', '26.5'),

('Fila Valira Velcro Kids', '27.5'),

('Fila Valira Velcro Kids', '28 1/3'),

('Fila Valira Velcro Kids', '26 1/2'),

('Nike Activate ST', 'XXL'),

('Under Armour Comfort Socks', '9-10'),

('Adidas Euroleague Ball', 'Size seven'),

('Puma Freetrack', '42 1/2'),

('Adidas Outrun XLR2', 'XXL'),

('Puma Freetrack', '30'),

('Nike Activate ST', 'S'),

('Under Armour Comfort Socks', '7-8');

SELECT *

FROM @PRODUCTS

ORDER BY NAME ASC, SIZE ASC