烛少

分类

题解(53)

/ 注册

全部文章（共68篇）

题解 | #10月的新户客单价和获客成本#

select round(avg(avg_a),1) avg_amount,round(avg(avg_in-avg_a),1) as avg_cost from (select uid,avg(total_amount) avg_a,sum(cnt*price) avg_in from (sele...

Mysql

2022-01-21

0 366

题解 | #零食类商品中复购率top3高的商品#

with a as( select tod.product_id,uid,cnt,event_time from tb_order_detail tod,tb_product_info tpi,tb_order_overall too where tod.product_id...

Mysql

2022-01-21

0 336

题解 | #某店铺的各商品毛利率及店铺整体毛利率#

with a as (select tod.product_id,tod.price,in_price,tod.cnt from tb_order_overall too,tb_order_detail tod,tb_product_info tpi where too.order_id=tod.o...

Mysql

2022-01-20

0 332

题解 | #各城市最大同时等车人数#

with a as( select city,event_time,date(event_time) as dt,start_time,end_time from tb_get_car_record t2,tb_get_car_order t1 where t1.order_id=t2.order_...

Mysql

2022-01-20

0 347

题解 | #国庆期间近7日日均取消订单量#

with a as( select date(order_time) od, count(start_time) as deal, count(order_id)-count(start_time) nodeal from tb_get_car_order t1 ...

Mysql

2022-01-20

1 395

题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

select city,driver_id,avg_grade,avg_order_num,avg_mileage from (select *,dense_rank() over(partition by city order by avg_order_num desc) rank1 from (...

Mysql

2022-01-20

0 376

题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

with a as( select user_id,sales_date from sales_tb st group by user_id,sales_date order by user_id,sales_date) select user_id,days_count from (select ...

Mysql

2022-01-20

0 250

题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

with a as( select user_id,sales_date from sales_tb st group by user_id,sales_date order by user_id,sales_date) select user_id,days_count from (select ...

Mysql

2022-01-20

0 316

题解 | #某宝店铺动销率与售罄率#

with a as( select item_id,sum(sales_num) s1,sum(sales_price) s2 from sales_tb group by item_id) select style_id,round(sum(s1)/sum(inventory-s1)*100,2)...

2022-01-20

0 273

题解 | #牛客直播各科目同时在线人数#

with st as ( select course_id,in_datetime from attend_tb at group by course_id,in_datetime ) select a.course_id,course_name,max(cnt) max_n...

Mysql

2022-01-19

1 572