SELECT ProductNumber 产品编号, 种类 = CASE ProductLine WHEN 'R' THEN '公路' WHEN 'M' THEN 'Mountain' WHEN 'T' THEN 'Touring' WHEN 'S' THEN 'Other sale items' ELSE '非卖品' END, Name 名称 FROM Production.Product
