96nnnnie

分类

题解(6)

/ 注册

全部文章（共3篇）

题解 | #查看学校名称中含北京的用户#

select emp_salary.emp_no,emp_salary.manager_no,emp_salary.emp_s,salaries.salary from (select t1.emp_no,s.salary as emp_s,t1.dept_no,t1.manager_no as m...

Mysql

2021-10-11

0 315

题解 | #查看学校名称中含北京的用户#

select university ,avg(question_cnt) as avg_question_cnt,avg(answer_cnt) as avg_answer_cntfrom user_profilegroup by universityhaving avg(question_cnt)...

2021-08-25

11 829

题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#

join+group by + order by逆序排列 ASCselect titles.title,AVG(salaries.salary) as avgfrom titles join salarieswhere titles.emp_no = salaries.emp_nogroup by ...

2021-08-23

0 395