with a as ( select product_id ,count(*) count from user_client_log where step = 'order' group by 1 ) select product_id ,count cnt from a where count = (select max(count) from a)