with a as ( select substring_index(order_id,'_',-1) product_id ,count(*) cnt from order_log group by 1 ) select product_id ,cnt from a where cnt = (select max(cnt) from a) order by 1