select
    uid,
    count(step) as cnt
from 
    user_client_log
where 
    step='order'
group by 
    uid
order by 
    row_number() 
    over(partition by uid order by count(step) asc,uid desc) asc 
limit 
    3