摘要:
SELECT SUM( c_orders.payment ) AS "销售额GMV", SUM( IF ( member_level > 0, c_orders.payment, 0 )) AS "会员销售额GMV", sum( after_refund_payment ) AS "净销售额", S 阅读全文
摘要:
复购率 SELECT a.NAME, 下单年月, COUNT( c ) AS 下单人数, COUNT( IF ( c > 1, 1, NULL ) ) AS 复购人数, concat(round( COUNT( IF ( c > 1, 1, NULL ) ) / COUNT( c ) * 100, 阅读全文