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