牛客794288350号

分类

/ 注册

全部文章（共50篇）

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

select u.vip, count(*) as visit_nums, count(distinct v.user_id) as visit_users from visit_tb v join uservip_tb u on v.user_id=u....

2025-06-12

0 25

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

select DISTINCT b.user_id from (select a.user_id, date_sub(a.date, interval a.rk D...

2025-06-11

0 17

题解 | 统计各岗位员工平均工作时长

SELECT s.post, ROUND(AVG(TIMESTAMPDIFF(minute,a.first_clockin,a.last_clockin)/60),3) AS work_hours FROM staff_tb s JOIN attendent_tb ...

2025-06-11

0 24

题解 | 查询培训指定课程的员工信息

SELECT s.staff_id, s.staff_name FROM staff_tb s JOIN cultivate_tb c ON s.staff_id=c.staff_id WHERE c.course LIKE '%course3%' ORDE...

2025-06-11

0 27

题解 | 最长连续登录天数

SELECT user_id, MAX(consec_days) AS max_consec_days FROM ( SELECT b.user_id, b.first_date, ...

2025-06-10

0 14

题解 | 每个月Top3的周杰伦歌曲

SELECT t.month, t.ranking, t.song_name, t.play_pv FROM (SELECT MONTH(p.fdate) AS month, s.song_name, COUNT...

2025-06-10

0 14

题解 | 最受欢迎的top3课程

SELECT s.cid, t.pv, t.time as time_len FROM ( SELECT cid, AVG(score) AS avg_score FROM ...

2025-06-10

0 15

题解 | 更新员工信息表

SELECT I.EMPLOYEE_ID, CASE WHEN I.LAST_UPDATE_DT >= U.UPDATE_DT THEN I.POSITION ELSE U.NEW_POSITION END AS POSITION, CA...

2025-06-10

0 16

题解 | 输出播放量最高的视频

SELECT cid, ROUND(MAX(peak_uv),3) as max_peak_uv FROM ( SELECT cid, SUM(tag) over(partition by cid ORDER BY time) as peak...

2025-06-09

0 20

题解 | 每个顾客购买的最新产品名称

SELECT t.customer_id, t.customer_name, t.product_name as latest_order FROM (SELECT c.customer_id, c.customer_name, ...

2025-06-09

0 20