lucky_bot/magic_server/sql/dev.sql

-- 数据分析sql
-- 节点售卖数量
select count(1),sum(quantity),sum(amount1),sum(amount2) from user_product;
select count(1),sum(amount1),sum(amount2) from user_product where status = 0;
select source,count(1),sum(quantity),sum(amount1),sum(amount2) from user_product where status = 0 group by source;

--todo: 主业务数据分析