All items with these criteria are: Material=Aluminum, Thickness=SELECT Convert(Int, Thickness) TheField, Count(DISTINCT Product.ProductID) TheCount FROM Product with (NOLOCK) INNER JOIN ProductVariant with (NOLOCK) ON Product.ProductID = ProductVariant.ProductID WHERE Grade='6061' AND Convert(Int, Thickness) IS NOT NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other, Finish=Other