我能找到工作吗？

分类

题解(26)

/ 注册

全部文章（共23篇）

题解 | #nico和niconiconi#

import java.util.Scanner; public class Main{ public static void main(String[] args){ Scanner sc=new Scanner(System.in); String lin...

Java

2021-10-21

0 489

题解 | #不相邻取数#

import java.util.Scanner; public class Main{ public static void main(String[] args){ Scanner sc=new Scanner(System.in); l...

Java

2021-10-21

0 395

题解 | #统计作答次数#

最大子序列，注意类型转换。 public class Main{ public static void main(String[] args){ Scanner in=new Scanner(System.in); long n=Long.parseLong(...

Java

2021-10-21

1 412

题解 | #统计作答次数#

select count(er.id) as total_pv, sum(case when er.submit_time is not null then 1 else 0 end) as complete_pv, count(distinct case when er...

Mysql

2021-10-21

0 356

题解 | #SQL类别高难度试卷得分的截断平均值#

SELECT ei.tag,ei.difficulty, ROUND((SUM(er.score)-max(er.score)-MIN(score))/(count(er.score)-2),1) clip_avg_score FROM examination_info ei join exam_...

Mysql

2021-10-21

0 359

题解 | #对所有员工的薪水按照salary降序进行1-N的排名#

判断是否为NULL用is select f.film_id,f.title from film f left join film_category fi on f.film_id=fi.film_id where fi.category_id is NULL;

Sqlite

2021-10-08

0 278

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

select d.dept_no,d.dept_name,count(*) sum from (departments d inner join dept_emp de on d.dept_no=de.dept_no) t inner join salaries s on t.emp_no=s...

Sqlite

2021-10-06

0 270

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

select last_name,first_name,dept_name from (employees e left join dept_emp d on e.emp_no=d.emp_no) t left join departments de on t.dept_no=de.dept_no;

Sqlite

2021-10-06

0 278

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

不同类型用group by先分组，再用order by排序 select t.title,avg(s.salary) as average from titles as t join salaries as s on t.emp_no = s.emp_no group by t.title ord...

Sqlite

2021-10-06

0 336

题解 | #获取所有员工当前的manager#

select dept_emp.emp_no as emp_no, dept_manager.emp_no as manager_no from dept_emp, dept_manager where dept_emp.dept_no=dept_manager.dept_no and dept_e...

Sqlite

2021-10-06

1 301