Hope this will meet your requirement:

select log_ticket, count( distinct curr_group) from #log

group by log_ticket

Output of above query is same as you needed.