咖啡加不加糖
咖啡加不加糖
全部文章
分类
题解(54)
归档
标签
去牛客网
登录
/
注册
咖啡加不加糖的博客
全部文章
(共53篇)
题解 | #店铺901国庆期间的7日动销率和滞销率#
select o7.date_time,o7.sale_rate,o7.unsale_rate from ( select distinct DATE_FORMAT(o5.event_time,'%Y-%m-%d') as event_time from ...
Mysql
2021-12-10
7
751
题解 | #连续签到领金币#
select t4.uid,t4.month,sum(t4.coin) from ( # 生成登录天数对应金币数 select t3.uid,date_format(t3.sym,'%Y%m') as month, (case when t3.rank_sym % 7 = 3 then 3 ...
Mysql
2021-12-10
1
334
题解 | #10月的新户客单价和获客成本#
select round(sum(t2.total_amount)/count(*),1) as avg_amount ,round((sum(t3.cnt_all)-sum(t2.total_amount))/count(*),1) as avg_cost from # 查询订单表中,每个订单...
Mysql
2021-12-06
0
332
首页
上一页
1
2
3
4
5
6
下一页
末页