select
case grouping( CONVERT(VARCHAR(20),CONVERT(DECIMAL(20,0),SSP.SeatTicketTypePrice)))when 0 then CONVERT(VARCHAR(20),CONVERT(DECIMAL(20,0),SSP.SeatTicketTypePrice))
when 1 then '总计'
end as 'XX',
COUNT(O.orderId ) '单数',SUM(O.ticketCount) '张数'
from [Order] O
inner join [OrderElec] oe on O.orderId =oe.OrderId and oe.PrintType>0
inner join [SessionSeatPriceType] SSP on SSP.SeatTicketTypeSessionId=O.sessionId and O.orderSellPriceType=SSP.seatTicketTypePriceID
where O.sessionid =XX
and O.orderType=XX
and O.orderMode=XX
and O.orderVisable=XX
and O.orderPayment=XX
group by CONVERT(VARCHAR(20),CONVERT(DECIMAL(20,0),SSP.SeatTicketTypePrice)) with Rollup