谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共138篇）

题解 | 某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级

with t1 as ( select answer_date, author_id from answer_tb group by answer_date, author_id ) sel...

2026-02-25

0 46

题解 | 牛客直播各科目同时在线人数

with t1 as ( select course_id, in_datetime as dt, 1 as alpha from attend_tb union all select ...

2026-02-25

0 52

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

with t1 as ( select course_id, sum(if_sign) as sign_cnt from behavior_tb group by course_id ), t2 as ( ...

2026-02-21

0 34

题解 | 某宝店铺连续2天及以上购物的用户及其对应的天数

with t1 as ( select user_id, sales_date from sales_tb where month(sales_date) = 11 group by ...

2026-02-21

0 39

题解 | 工作日各时段叫车量、等待接单时间和调度时间

with t1 as ( select t.uid, t.event_time, t.end_time, t.order_id, t.period, tb_get_car_order.order_...

2026-02-19

0 41

题解 | 10月的新户客单价和获客成本

with t1 as ( select uid from tb_order_overall group by uid having date_format(min(event_time),'%Y-%m...

2026-02-15

0 43

题解 | 连续签到领金币

with t1 as ( select distinct uid, date(in_time) as dt from tb_user_log where date(in_time) between '202...

2026-02-15

0 43

题解 | 统计活跃间隔对用户分级结果

with tb_user_grade as ( select uid, case when min(date(in_time)) between date_sub('2021-11-04',interval 6 day) and '20...

2026-02-14

0 36

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

with tb_with_tag as ( select tag, date(tb_user_video_log.start_time) as dt, if_like, if_retweet from ...

2026-02-13

0 46

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

with 2025_resume as ( select job, substr(date,1,7) as first_year_mon, sum(num) as first_year_cnt from resume_...

2026-01-19

0 50