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