swaaaay

题解

未归档(36)

/ 注册

全部文章 / 题解（共76篇）

题解 | #查找所有员工的last_name和first_name以及对应的dept_name# 来自专栏

select e.last_name,e.first_name,ifnull(dep.dept_name,null) from ((employees e left join dept_emp d on e.emp_no=d.emp_no) m left join departments dep o...

Sqlite

2021-12-22

0 381

题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary# 来自专栏

SELECT e.emp_no,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(salary)...

Mysql

2021-12-22

0 362

题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary# 来自专栏

薪资第一和第二都可能有多名，所以需要group by SELECT emp_no,salary FROM salaries s WHERE salary= ( SELECT salary FROM salaries GROUP BY salary ORDER BY salary...

Mysql

2021-12-22

0 378

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

SELECT t.title, avg(s.salary) FROM titles t INNER JOIN salaries s on t.emp_no=s.emp_no GROUP BY t.title ORDER BY avg(s.salary);

Sqlite

2021-12-22

0 284

题解 | #查找employees表emp_no与last_name的员工信息# 来自专栏

SELECT * FROM employees WHERE emp_no%2!=0 AND last_name !='Mary' ORDER BY hire_date DESC;

Mysql

2021-12-15

0 309

题解 | #获取每个部门中当前员工薪水最高的相关信息# 来自专栏

sqlite SELECT de.dept_no,de.emp_no, max(s.salary) maxSalary FROM dept_emp de INNER JOIN salaries s ON de.emp_no=s.emp_no GROUP BY de.dept_no;

Sqlite

2021-12-15

1 266

题解 | #获取所有员工当前的manager# 来自专栏

SELECT de.emp_no,dm.emp_no manager FROM dept_emp de LEFT JOIN dept_manager dm on de.dept_no=dm.dept_no WHERE de.emp_no!=dm.emp_no;

Mysql

2021-12-15

1 426

题解 | #扑克牌大小# 来自专栏

def get_ans(s1,s2): # 王炸 if s1=='joker JOKER' or s2=='joker JOKER': return 'joker JOKER' # 个子对子三个顺子炸弹之间 keys=[str(i) for i in range(3...

Python3

2021-12-14

1 597

题解 | #密码验证合格程序# 来自专栏

用python集合挺方便的 def get_ans(s): return 'OK' if (len(s)>8 and three_types(s) and sub_str(s)) else 'NG' def three_types(s): mark=set() for...

Python3

2021-12-14

1 582

题解 | #合并表记录# 来自专栏

def get_ans(li): ans=dict() for i in range(int(li[0])): key,val=li[i+1].split(' ') key,val=int(key),int(val) ans[key]=...

Python3 数组

2021-12-14

0 364