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
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