select
uid,count(trace_id) as cnt 


from 

user_client_log

where step='order'

group by 
uid

order by cnt desc 

limit 3