云水间

分类

/ 注册

全部文章（共28篇）

题解 | 汽水瓶

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

2025-06-20

0 13

题解 | 牛客每个人最近的登录日期(二)

select u.name as u_n, c.name as c_n, t.date from login l join user u on l.user_id=u.id join client c on l.client_id=c.id join ( s...

2025-03-16

0 39

题解 | 牛客每个人最近的登录日期(四)

select l1.date,sum(l1.date=l2.date) as new from login l1 left join ( select user_id ,min(date) as date from login group b...

2025-03-13

0 23

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

select t1.emp_no as emp_no, t2.emp_no as manager_no, t1.salary as emp_salary, t2.salary as manager_salary from ( -- 普通员工部门薪水 ...

2025-03-11

0 34

题解 | 查找在职员工自入职以来的薪水涨幅情况

select t1.emp_no, (t2.salary - t1.salary) as growth from ( select e.emp_no, s.salary from ...

2025-03-11

1 40

题解 | 作答试卷得分大于过80的人的用户等级分布

SELECT u.level ,count(u.uid) as level_cnt from user_info u join exam_record er on u.uid=er.uid and er.score>80 join examination_info ei on...

2025-03-08

0 45

题解 | 浙大不同难度题目的正确率

select qd.difficult_level, round(sum(qp.result='right')/count(qd.question_id),4) as correct_rate from user_profile u join question_practice_de...

2025-03-03

0 37

题解 | 统计复旦用户8月练题情况

select u.device_id, u.university, count(q.question_id) as question_cnt, sum(q.result='right') as right_question_cnt from use...

2025-03-02

0 34

题解 | 找出每个学校GPA最低的同学

select device_id, university, gpa from user_profile where (university,gpa) in ( select university,min(gpa) from user_profile group by univ...

2025-03-02

0 38

题解 | #字母统计#

#include <stdio.h> #define MAX 1000 int main() { char str[MAX]={0}; char A[26]="ABCDEFGHIJKLMNOPQRSTUVWXYZ"; gets(str); int l=st...

2023-02-13

0 287