L重启中

分类

/ 注册

全部文章（共51篇）

题解 | 商品销售排名

with a as ( select t2.product_name product_name ,t2.price price ,count(*) cnt from user_client_log t1 join product_info t2 on t1.product_id ...

2026-03-15

0 15

题解 | 用户购买次数前三

select uid ,count(*) cnt from user_client_log where step = 'order' group by 1 order by 2 desc,1 limit 3

2026-03-15

0 14

题解 | 下单最多的商品

with a as ( select product_id ,count(*) count from user_client_log where step = 'order' group by 1 ) select product_id ,count cnt from a where...

2026-03-15

0 13

题解 | 下单最多的商品

with a as ( select t1.product_id product_id ,count(*) count from user_client_log t1 join product_info t2 on t1.product_id = t2.product_id whe...

2026-03-15

0 16

题解 | 统计快递从创建订单到发出间隔时长

select round(avg(timestampdiff(minute,t1.create_time,t2.out_time)/60),3) time from express_tb t1 join exp_action_tb t2 on t1.exp_number = t2.exp_numbe...

2026-03-15

0 19

题解 | 查询产生理赔费用的快递信息

select t2.exp_number exp_number ,t2.exp_type exp_type ,t1.claims_cost claims_cost from exp_cost_tb t1 join express_tb t2 on t1.exp_number = t2.exp_nu...

2026-03-15

0 16

题解 | 淘宝店铺的实际销售额与客单价

select round(sum(t1.sales_num*t2.goods_price),3) sales_total ,round(sum(t1.sales_num*t2.goods_price)/count(distinct t1.user_id),3) per_trans from sal...

2026-03-15

0 14

题解 | 淘宝店铺的实际销售额与客单价

select sum(t1.sales_num*t2.goods_price) sales_total ,round(sum(t1.sales_num*t2.goods_price)/count(distinct t1.user_id),3) per_trans from sales_tb t1 ...

2026-03-15

0 16

题解 | 查询成绩

select count(*) from ( select t1.sId from Student t1 join SC t2 on t1.sId = t2.sId group by 1 having avg(t2.score) > 60 ) a

2026-03-15

0 16

题解 | 商品交易(网易校招笔试真题)

select t1.id ,t1.name ,t1.weight ,sum(t2.count) total from goods t1 join trans t2 on t1.id = t2.goods_id where t1.weight < 50 group by 1,2,3 ha...

2026-03-15

0 17