摘要： select sum(case when xseventype'' then 1 else 0 end), sum(case when zaeventype'' then 1 else 0 end),hotelcode from info_hotelevent group by hotelcode 阅读全文