牛客984572812号

分类

/ 注册

全部文章（共17篇）

题解 | 10月的新户客单价和获客成本

WITH T1 AS ( SELECT *, row_number() over(partition by uid order by event_time) rn FROM tb_order_overall ), T2 AS ( SELECT ...

2025-03-06

0 60

题解 | 零食类商品中复购率top3高的商品

WITH T1 AS ( SELECT uid, product_id, if(count(event_time)>1,1,0) repurchase FROM tb_order_detail C JOIN tb_product_info A USING(product_id) JOIN tb...

2025-03-06

0 59

题解 | 每个城市中评分最高的司机信息

WITH T1 AS ( SELECT driver_id, city, round(avg(grade),1) 平均评分, round(count(order_id)/count(DISTINCT date(order_time)),1) 接单数量, ...

2025-02-20

0 72

题解 | 牛客直播各科目出勤率

WITH T1 AS ( SELECT course_id, course_name, count(DISTINCT user_id) chuqinrenshu FROM attend_tb JOIN course_tb USING(c...

2025-02-19

0 90

题解 | 异常的邮件概率

SELECT date, round(sum(CASE WHEN type = 'no_completed' THEN 1 ELSE 0 END)/count(type),3) FROM email e JOIN user u ON e.send_id = u.id ...

2025-02-17

0 80

题解 | 获取所有非manager员工当前的薪水情况

WITH T1 AS ( SELECT * FROM employees e JOIN dept_emp de USING(emp_no) WHERE e.emp_no NOT IN ( SELECT ...

2025-02-16

0 56

题解 | 查找在职员工自入职以来的薪水涨幅情况

先创建两张表： 1.初始工资表：用hire_date = from_date作为表连接条件来筛选，工资合同开始日期为该员工进公司的第一天，即该员工在公司最初的工资 2.当前工资表：用WHERE to_date = '9999-01-01'作为条件，筛选出在职员工的最新合同接着连接两张表，用当前...

2025-02-16

0 75

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

WITH T1 AS ( SELECT max(salary) maxsalary FROM salaries ), T2 AS ( SELECT max(salary) secondsalary FROM salaries WHERE sa...

2025-02-16

0 67

题解 | 查询连续登陆的用户

WITH T1 AS ( SELECT user_id, date(log_time) fdate, row_number() over(partition by user_id order by date(log_time)) rn ...

2025-02-15

0 87

题解 | 最长连续登录天数

WITH t1 AS ( SELECT user_id, fdate, ROW_NUMBER() OVER(PARTITION BY user_id ORDER BY fdate) rn FROM tb_dau ...

2025-02-15

0 68