求一条产品销售量，包括产品属性参数的sql语句解决方案

求一条产品销售量，包括产品属性参数的sql语句
第一步：现有数据如下，ProductId产品id, OrderId代表订单编号，ShipmentQuantity该产品的该订单的销售量,ValueId产品所属参数id, ValueStr产品参数名称，
ProductId            OrderId     ShipmentQuantity     ValueId     ValueStr     ProductName                                                                                                                                                                                            

45                   201403306241956          1                    72          M                  产品1                                                                                                                                                                                          
48                   201402195799492          2                    73          L                   产品2                                                                 
48                   201403306241956          2                    75          XXL              产品2                                                                                                                                                                                            
48                   201402195799492          2                    92          灰色             产品2