with a as( select date(order_time) as ot,count(distinct user_id) as order_number from order_tb group by date(order_time) ), b as( select date(visit_time) as vt,count(distinct user_id) as v_number from visit_tb group by date(visit_time) ) select a.ot as date, concat(round(order_number*1.0/v_number*10...

  「求助大佬帮看看这道算法题吧！」有贷款信息表：loan_tb（agreement_id：合同id，customer_id：客户id，loan_amount：贷款金额，pay_amount：已还... https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9