StevenCMY

分类

/ 注册

全部文章（共5篇）

题解 | 实习广场投递简历分析(三) - 简单题

with t as ( select id, job, DATE_FORMAT (date, '%Y-%m') as date, num from ...

2025-06-12

0 42

题解 | 计算用户的平均次日留存率 - 其实我觉得这道题才是最难的（思维上）

select count(device2) / count(device1) as avg_ret from ( select distinct t1.device_id as device1, t1.date as d...

2025-06-09

0 29

题解 | 找出每个学校GPA最低的同学 - 依然面试前紧集复健窗口函数

select device_id, university, gpa from ( select device_id, university, gpa, ro...

2025-06-08

0 31

题解 | 每个月Top3的周杰伦歌曲 - 你发如雪凄美了离别我焚香感动了谁🎶

with tm as ( select month, song_name, song_id, count(*) as play_pv from ...

2025-06-06

0 56

题解 | 统计每个产品的销售情况 - 子查询加加加加到厌倦

with t as ( select t1.product_id, t1.order_id, t1.customer_id, t1.quantity, t1...

2025-06-06

0 46