牛客727894600号

分类

题解(24)

/ 注册

全部文章（共37篇）

题解 | #商品交易(网易校招笔试真题)#

SELECT goods_id AS id, name, weight, SUM(count) AS total FROM trans AS T LEFT JOIN goods AS G ON G.id = T.goods_id GROUP BY ...

2023-09-11

0 384

题解 | #获得积分最多的人(一)#

SELECT name, SUM(grade_num) AS grade_num FROM ( SELECT U.name AS name, G.grade_num AS grade_num FR...

2023-09-11

0 379

题解 | #实习广场投递简历分析(二)#

SELECT job, # LEFT(date, 7) AS mon, DATE_FORMAT(date,'%Y-%m') AS mon, SUM(num) AS cnt FROM resume_info WHERE # date LIKE '2025...

2023-09-08

0 281

题解 | #汇总各个部门当前员工的title类型的分配数目#

SELECT D.dept_no, D.dept_name, T.title, COUNT(T.title) AS count FROM dept_emp AS DE LEFT JOIN titles AS T ON T.emp_no = DE.emp...

2023-08-30

1 288

题解 | #统计各个部门的工资记录数#

SELECT D.dept_no, D.dept_name, COUNT(S.salary) AS sum FROM salaries AS S LEFT JOIN dept_emp AS DE ON DE.emp_no = S.emp_no LEFT...

2023-08-30

1 360

查找所有员工的信息

SELECT e.last_name, e.first_name, d.dept_no FROM employees AS e LEFT JOIN dept_emp AS d ON d.emp_no = e.emp_no;

2023-08-25

2 470

查找所有已经分配部门的员工的信息

方法一: SELECT e.last_name, e.first_name, de.dept_no FROM employees AS e, dept_emp AS de WHERE de.emp_no = e.emp_no; 方法二: SE...

2023-08-25

1 373

题解 | #查找当前薪水详情以及部门编号dept_no#

方法一: SELECT S.emp_no, S.salary, S.from_date, de.to_date, de.dept_no FROM salaries AS S, dept_manager AS de WHERE de....

2023-08-25

2 326

题解 | #查找入职员工时间排名倒数第三的员工所有信息#

SELECT * FROM employees WHERE hire_date = ( SELECT DISTINCT hire_date FROM employees ORDER...

2023-08-25

1 355

题解 | #牛客网Python用户的成就值#

import pandas as pd df = pd.read_csv(r"Nowcoder.csv", sep=",", dtype=object) res = df[df["Language"] == "Python&qu...

2023-08-24

1 278