__hello__world

分类

/ 注册

全部文章（共24篇）

题解 | 商品价格排名

select product_id, product_name, type, price from ( select *, row_number() over ( ...

2025-04-22

0 54

题解 | 下单最多的商品

select product_id, count(*) as cnt from user_client_log where step = 'order' group by product_id order by product_id limit 1;

2025-04-21

0 50

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

select round( avg( timestampdiff (minute, create_time, out_time) / 60 ), 3 ) as time from express_tb e...

2025-04-21

0 53

题解 | 统计快递运输时长

select exp_type, round( avg(timestampdiff (minute, ec.out_time, ec.in_time)/60) * 1.0, 1 ) as time from express_tb et ...

2025-04-21

0 88

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

select sum(s.sales_num * g.goods_price) as sales_total, round( sum(s.sales_num * g.goods_price) / count(distinct s.user_id), 3...

2025-04-20

0 54

题解 | 查询成绩

select count(*) from ( select avg(score) as 平均成绩 from Student St left join SC S using (sid...

2025-04-20

0 49

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

select gs.id, gs.name, gs.weight, a.total from goods gs left join (select goods_id,sum(count) as total ...

2025-04-17

0 78

题解 | 每天登陆最早的用户的内容喜好

select t1.log_day, t1.user_id, t1.hobby from ( select date (log_time) as log_day, lt.user_id, ...

2025-03-03

0 56

题解 | 统计加班员工占比

select department, concat (round(100 * avg(is_time), 1), '%') as ratio from ( select staff_id, if ( ...

2025-03-01

0 51

题解 | 统计各个部门平均薪资

select department, round(avg(normal_salary - dock_salary), 3) as avg_salary from staff_tb st join salary_tb sa using (staff_id) #实发薪资剔...

2025-03-01

0 63