eagle10

分类

/ 注册

全部文章（共29篇）

题解 | 返回顾客名称和相关订单号以及每个订单的总价

select cust_name,order_num, quantity*item_price as OrderTotal from OrderItems left join Orders using(order_num) left join Customers using(cust_id) ord...

2025-03-25

0 41

题解 | 查询订单

select t1.order_id,t1.customer_name,t1.order_date from( select orders.order_id ,customers.customer_name, orders.order_date,rank() over(partition by o...

2025-03-20

0 41

题解 | 每个部门薪资排名前两名员工

select department,employee_name,salary from (select department,employee_name,salary, rank() over (partition by department order by salary desc) as p...

2025-03-20

0 34

题解 | 2021年11月每天的人均浏览文章时长

SELECT DATE_FORMAT(in_time, '%Y-%m-%d') AS dt, round(sum(TIMESTAMPDIFF(SECOND, in_time, out_time))/count(distinct uid),1) AS avg_view_len_sec...

2025-03-20

0 35

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

with t1 as ( SELECT rank() over(partition by date(lb.log_time) order by lb.log_time) as paiming ,user_id,date(lb.log_time) as log_day,lb.log...

2025-03-10

0 45

题解 | 统计加班员工占比

with t1 as( select sb.department,count(*) as people from staff_tb as sb left join attendent_tb as ab on sb.staff_id=ab.staff_id group by sb.departmen...

2025-03-09

0 50

题解 | 统计商家不同会员每日访问人次及访问人数

with t1 as ( select ub.vip,count(*) as visit_nums from visit_tb as vb left join uservip_tb as ub on vb.user_id=ub.user_id group by ub.vip), t2 as (...

2025-02-16

0 50

题解 | 推荐内容准确的用户平均评分

select distinct round(avg(distinct score),3) as avg_score from recommend_tb as rb right join user_action_tb as ub on rb.rec_user=ub.user_id where rb.r...

2025-02-15

0 52

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

select st.department ,avg((sb.normal_salary - sb.dock_salary)) as avg_salary from staff_tb as st left join salary_tb as sb on st.staff_id=sb.staff_...

2025-02-15

0 23