qq_42364589的博客

请计算在 2020 年第一季度的购买人数，销售金额， 客单价， 客单件， 人均购买频次。注：客单价：平均订单金额；客单件：平均订单购买件数。select count(distinct(customer_id)), sum(price*quantity), sum(price*quantity)/count(order_id), sum(quantity)/count(order_id), count(order_id)/count(distinct(customer_id))from `order.