当赤道留住雪花aiz

分类

/ 注册

全部文章（共4篇）

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

with t1 as( select job,date_format(date,'%Y-%m') as mon,month(date) as m,sum(num) as cnt from resume_info where year(date)=2025 group ...

2024-08-18

0 122

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

with t1 as( select user_id,date_format(reg_time,'%Y-%m-%d') as fisrt_time, date_format(log_time,'%Y-%m-%d') as log_time1, ro...

2024-08-15

0 138

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

select s.staff_id,staff_name from staff_tb s join cultivate_tb using(staff_id) where course like '%course3%' order by s.staff_id

2024-08-14

0 142

题解 | #统计所有课程参加培训人次#

with t1 as( select case when course like '%course1%' then 1 else 0 end as c1, case when course like '%course2%' then 1 else 0 end as c2...

2024-08-14

6 130