Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software to find the mountain bikes models color and weight:

USE AdventureWorks;

SELECT Name, CatalogDescription.query('
declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";
<Product ProductModelID="{ (/p1:ProductDescription/@ProductModelID)[1] }">
{
/p1:ProductDescription/p1:Specifications/Color,
/p1:ProductDescription/p1:Specifications/Weight
}
</Product> ') as Result
FROM Production.ProductModel
WHERE CatalogDescription is not null;