路静

分类

/ 注册

全部文章（共49篇）

题解 | 对商品的销售情况进行深度分析

select category product_category, age_group, sum(price*quantity) total_sales_amount, round(sum(price*quantity)/sum(sum(price*quantity)) over (partitio...

2025-07-26

0 48

题解 | 最受欢迎的top3课程

select p.cid, count(*) pv, round(sum(timestampdiff(minute,start_time,end_time)),3) time_len from course_info_tb c right join play_record_tb p on c.cid...

2025-07-26

0 68

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

select cid, round(cast(max(cnt) as float),3) as max_peak_uv from( select a.cid, sum(if(a.start_time between b.start_time and b.end_time,1...

2025-07-26

2 58

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

select s.department, round(avg(a.normal_salary-a.dock_salary),2) average_actual_salary, ifnull(round(avg(case when s.staff_gender='male' then a.normal...

2025-07-26

0 66

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

select customer_id, customer_name, product_name latest_order from ( select d.customer_id, customer_name, product_name, row_number() ov...

2025-07-26

0 46

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

select customer_id, customer_name, product_name latest_order from ( select d.customer_id, customer_name, product_name, row_number() ov...

2025-07-26

0 47

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

select order_id, customer_name, order_date from ( select order_id, customer_name, order_date, rank() over (partition by customer_name ...

2025-07-18

0 69

题解 | 商品id数据清洗统计

select product_id, count(*) cnt from ( select substring(order_id from 6 for 9) product_id from order_log ) as t group by product_id order by c...

2025-07-17

0 55

题解 | 商品销售总额分布

select if(pay_method='','error',pay_method) pay_method, count(*) cnt from user_client_log u join product_info p using(product_id) where product_name='...

2025-07-14

0 37

题解 | 完成员工考核试卷突出的非领导员工

select em.emp_id emp_id, em.emp_level emp_level, info.tag exam_tag from emp_info em join exam_record re on em.emp_id=re.emp_id join examination_info i...

2025-07-11

0 37