牛客煲
牛客煲
全部文章
分类
题解(10)
归档
标签
去牛客网
登录
/
注册
牛客煲的博客
全部文章
(共12篇)
题解 | #平均播放进度大于60%的视频类别#
select tag, concat(round(avg(if(TIMESTAMPDIFF(second,start_time,end_time)>=duration,1,TIMESTAMPDIFF(second,start_time,end_time)/duration))*100...
2022-05-25
0
118
题解 | #浙大不同难度题目的正确率#简单理解
SELECT difficult_level, SUM( IF ( result = "right", 1, 0 ))/ COUNT( qpd.device_id ) AS correct_r...
2022-05-18
0
155
题解 | #统计复旦用户8月练题情况#简单理解
SELECT up.device_id, up.university, count( question_id ) AS question_cnt...
2022-05-18
0
173
题解 | #对所有员工的薪水按照salary降序进行1-N的排名#
答案: SELECT emp_no,salary, CASE WHEN @salary=s.salary THEN @rank WHEN @salary:=s.salary THEN @rank:=@rank+1 END as t_rank from salaries s,(SELECT @...
2021-09-14
0
189
题解 | #查找在职员工自入职以来的薪水涨幅情况#
答案: select e.emp_no, (s2.salary-s1.salary) growth from employees e join salaries s1 on e.emp_no=s1.emp_no and e.hire_date=s1.from_date //入职 join salar...
2021-09-13
0
179
题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
答案: SELECT e.emp_no,max(s.salary),e.last_name,e.first_name from employees e INNER JOIN salaries s ON e.emp_no=s.emp_no WHERE salary<(SELECT MAX(sal...
2021-09-13
0
204
题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#
答案: SELECT title,AVG(s.salary) as a from titles t INNER JOIN salaries s WHERE t.emp_no=s.emp_no GROUP BY title ORDER BY a asc 按title分组,计算平均工资并且按平均工资排序
2021-09-13
0
255
题解 | #获取每个部门中当前员工薪水最高的相关信息#
答案: SELECT re.dept_no,re.emp_no,re.salary FROM (SELECT dept_no,d.emp_no,salary FROM dept_emp d INNER JOIN salaries s on d.emp_no=s.emp_no ORDER BY s...
2021-09-13
1
251
题解 | #获取所有员工当前的manager#
答案: SELECT d.emp_no,dd.emp_no as manager FROM dept_emp d LEFT JOIN dept_manager dd ON d.dept_no=dd.dept_no WHERE d.emp_no NOT IN (SELECT de.emp_no F...
2021-09-13
1
379
题解 | #获取所有非manager的员工emp_no#
SELECT e.emp_no FROM employees e WHERE e.emp_no not in (SELECT e.emp_no FROM employees e INNER JOIN dept_manager d on e.emp_no = d.emp_no)筛选在部门的员工:SE...
2021-09-08
1
260
首页
上一页
1
2
下一页
末页