CTGU_21_hhf
CTGU_21_hhf
全部文章
分类
归档
标签
去牛客网
登录
/
注册
CTGU_21_hhf的博客
全部文章
(共3篇)
题解 | 查找在职员工自入职以来的薪水涨幅情况
select e.emp_no, s2.salary - s1.salary as growth from employees e join salaries s1 on e.emp_no = s1.emp_no join salaries s2 on e.emp_no ...
2025-02-27
1
54
题解 | 请写出计算粉丝ctr的sql语句
select sum(read_num)/sum(show_num) as fans_ctr from a join b on a.author_id = b.author_id join c on a.fans_id = c.fans_id and b.content_i...
2025-02-20
3
122
题解 | 查询连续登陆的用户
with tmp as ( select user_id, date_format(log_time, '%Y-%m-%d') as date from login_tb ) select distinct user_id ...
2025-02-19
1
113