牛客907689258号
牛客907689258号
全部文章
分类
归档
标签
去牛客网
登录
/
注册
牛客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
首页
上一页
1
2
3
4
下一页
末页