牛客907689258号

分类

/ 注册

全部文章（共32篇）

题解 | 给出employees表中排名为奇数行的first_name

WITH ranked AS ( SELECT first_name, ROW_NUMBER() OVER (ORDER BY first_name ASC) AS rn FROM employees ) SELECT e.first_name AS...

2026-04-05

0 24

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

With first_user AS ( select t1.log_id, t1.user_id, t1.log_time, t2.hobby, t2.score,rank() OVER ( PARTITION BY DATE(log_time) ...

2026-03-22

0 25

题解 | 最长连续登录天数

WITH base AS( SELECT user_id, fdate - ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY fdate) AS grp_key FROM tb_dau ), t AS ( ...

2026-02-24

0 49

题解 | 下单复盘

SELECT c.customer_id, c.customer_name, COUNT(DISTINCT o.order_id) AS feb_2024_order_count, COALESCE(SUM(ot.qty * ot.price), 0) AS feb_...

2026-02-07

0 48

题解 | 游戏平台新玩家消费与进阶行为分析

SELECT p.player_id, p.username, p.level AS current_level, CASE WHEN p.level >= 30 THEN '高阶玩家' ELSE '新秀玩家' END A...

2026-02-01

0 53

题解 | SaaS平台企业客户新功能采纳度分析

WITH first_usage AS ( SELECT team_id, DATE_FORMAT(MIN(usage_timestamp), '%Y-%m-%d') AS first_ever_usage_date FROM feature_usa...

2026-02-01

0 59

题解 | 智能家居设备高能耗异常监控分析

WITH device_usage AS ( -- ① 每台设备 2025年1月总用电量 SELECT t2.device_id, t2.device_name, t2.category, t2.location, ...

2026-02-01

0 68

题解 | 国庆期间每类视频点赞量和转发量

WITH result AS ( SELECT info.tag, DATE(log.start_time) AS dt, SUM(log.if_like) AS like_cnt, SUM(log.if_retweet)...

2026-01-29

0 44

题解 | 获取employees中的first_name

select first_name from employees order by right(first_name,2)

2026-01-27

0 51

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

select de.dept_no, de.emp_no, s.salary FROM employees e LEFT JOIN dept_emp de ON e.emp_no = de.emp_no LEFT JOIN salaries s ON e.emp_no = s.emp_no LEFT...

2026-01-27

0 53