呼吸丶zero

分类

/ 注册

全部文章（共18篇）

题解 | 最受欢迎的top3课程

select cid, count(*) as pv, floor(sum(tl)) as time_len from ( select cid, timestampdiff(second, start...

2025-07-18

1 8

题解 | 未下单用户统计

select cast(sum(case when product_id is null then 1 else 0 end) as signed ) as cnt from order_log right join user_info using(uid)

2025-07-16

0 9

题解 | 输出播放量最高的视频

WITH daily_events AS ( SELECT cid, DATE(event_time) AS dt, event_time, event_type FROM ( -- 生成开始事件 ...

2025-07-15

0 17

题解 | 每个顾客购买的最新产品名称

select customer_id ,customer_name ,product_name as latest_order from orders join customers using(customer_id) join products using(product_id) where (c...

2025-07-15

0 8

题解 | 每个顾客最近一次下单的订单信息

select order_id, customer_name, order_date from orders join customers using (customer_id) where order_date in ( select...

2025-07-14

0 10

题解 | 商品销售总额分布

select case when u.pay_method = '' then 'error' else u.pay_method end as pay_method, count(*) as num from user_client_...

2025-07-13

0 12

题解 | 商品价格排名

with t as ( select product_id, product_name, type, price, rank() over ( ...

2025-07-13

0 13

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

select department, average_actual_salary, if(average_actual_salary_male is null,0.00,average_actual_salary_male) as average_actual_salary_...

2025-07-13

0 19

题解 | 统计快递运输时长

select exp_type ,round(avg(timestampdiff(minute,out_time,in_time)/60),1) as time from express_tb join exp_action_tb using(exp_number) group by exp_typ...

2025-07-12

0 12

题解 | 查询单日多次下订单的用户信息？

select date(order_time) as order_date ,user_id ,count(*) as order_nums ,vip from order_tb join uservip_tb using(user_id) group by order_date,user_id h...

2025-07-10

0 21