在发呆的华夫饼很冷艳

分类

/ 注册

全部文章（共3篇）

题解 | 给出employees表中排名为奇数行的first_name

select first_name as first from employees where emp_no in ( select emp_no from ( s...

2024-12-18

0 42

题解 | 查找在职员工自入职以来的薪水涨幅情况

/* 假如是入职到现在只有一次涨薪，好像多次涨薪也适用，降薪也适用*/select s1.emp_no, (s2.salary - s1.salary) as growthfrom ( /*刚入职之后的第一次工资*/ select ...

2024-12-17

1 49

题解 | #推荐内容准确的用户平均评分#

select round(avg(score)) as avg_score from user_action_tb where hobby_l in ( select rec_info_l from recommend_tb where rec_user = user_id ...

2024-12-11

1 58