题解 | 未下单用户统计
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
select cast(sum(case when product_id is null then 1 else 0 end) as signed ) as cnt from order_log right join user_info using(uid)
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
select cast(sum(case when product_id is null then 1 else 0 end) as signed ) as cnt from order_log right join user_info using(uid)
相关推荐