我的名字在哪里

分类

/ 注册

全部文章（共44篇）

题解 | 连续签到领金币

-- 创建临时表 WITH a AS( SELECT uid, artical_id, DATE(in_time) dt, sign_in FROM tb_user_log ), b AS( SELECT uid, artical_id, dt, sign_in FR...

2026-04-09

0 27

题解 | 每篇文章同一时刻最大在看人数

WITH a AS( SELECT artical_id, uid, in_time checktime, 1 uv FROM tb_user_log WHERE artical_id != 0 UNION ALL SELECT artical_id, uid...

2026-04-09

0 21

题解 | 2021年11月每天的人均浏览文章时长

SELECT date dt, ROUND(SUM(watch_time)/COUNT(DISTINCT uid),1) avg_viiew_len_sec FROM( SELECT uid, artical_id, timestampdiff(SECOND,in_ti...

2026-04-09

0 18

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

SELECT ct.course_id, ct.course_name, ROUND((bi2.attend_cnt/bi1.app_cnt)*100,2) `attend_rate(%)` FROM( SELECT course_id, COUNT(DISTINCT user_id...

2026-04-09

0 22

题解 | 牛客直播开始时各直播间在线人数

SELECT c.course_id, c.course_name, COUNT(DISTINCT a.user_id) online_num FROM course_tb c JOIN attend_tb a USING(course_id) WHERE TIME(a.in_dateti...

2026-04-08

0 24

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

SELECT t2.tag, t2.d dt, week_like_sum sum_like_cnt_7d, week_max_retweet max_retweet_cnt_7d FROM ( SELECT t1.ta...

2026-04-08

0 20

题解 | 每个创作者每月的涨粉率及截止当前的总粉丝量

SELECT author, month, ROUND(SUM(if_follow)/COUNt(DISTINCT uid),3) fans_growth_rate, SUM(SUM(if_follow)) OVER (PARTITION BY author ORDER BY mo...

2026-04-08

0 16

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

SELECT fir.job, fir.first_year_mon, fir.first_year_cnt, sec.second_year_mon, sec.second_year_cnt FROM( SELECT job, date_format(date,'%Y-%m...

2026-04-08

0 22

题解 | 牛客每个人最近的登录日期(五)

SELECT da.date, IFNULL (ROUND(COUNT(DISTINCT l.user_id)/COUNT(bi1.user_id),3),0) FROM ( SELECT DISTINCT date FROM login ORDER BY date...

2026-04-08

0 15

题解 | 牛客的课程订单分析(七)

SELECT CASE WHEN c.name IS NULL THEN 'GroupBuy' ELSE c.name END source, COUNT(*) cnt FROM( SELECT id, user_id, product_name, status, client_i...

2026-04-08

0 16