跪求要一个offer

分类

题解(178)

/ 注册

TA的专栏 12篇文章 0人订阅

算法和编程题解

12篇文章 275人学习

全部文章（共183篇）

题解 | #四舍五入#

import java.util.Scanner; public class Main { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); double d= scanner.nex...

Java

2021-11-02

1 518

题解 | #类型转换#

import java.util.Scanner; public class Main { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); double d = scanner.ne...

Java

2021-11-02

0 424

题解 | #更新记录（二）#

UPDATE exam_record set submit_time='2099-01-01 00:00:00', score=0 where start_time<'2021-09-01 00:00:00' and submit_time is null;

Mysql

2021-11-01

0 332

题解 | #浙江大学用户题目回答情况#

select user_profile.device_id,question_practice_detail.question_id, question_practice_detail.result from user_profile,question_practice_detail where u...

Mysql

2021-11-01

1 309

题解 | #分组排序练习题#

select university,avg(question_cnt) as avg_question_cnt from user_profile group by university order by avg(question_cnt);

Mysql

2021-11-01

0 345

题解 | #分组过滤练习题#

select university,avg(question_cnt) as avg_question_cnt, avg(answer_cnt) as avg_answer_cnt from user_profile group by university HAVING avg(question...

Mysql

2021-11-01

0 308

题解 | #分组计算练习题#

select gender,university,count(id) as user_num, AVG(active_days_within_30) as avg_activate_day, avg(question_cnt) as avg_question_cnt from user_profil...

Mysql

2021-11-01

0 343

题解 | #计算男生人数以及平均GPA#

SELECT COUNT(gender) as male_num,AVG(gpa) as avg_gpa from user_profile where gender="male";

Mysql

2021-11-01

0 250

题解 | #操作符混合运用#

select device_id,gender,age,university,gpa from user_profile where gpa>3.5 and university="山东大学" OR gpa>3.8 and university="复旦大学";

Mysql

2021-11-01

0 269

题解 | #Where in 和Not in#

SELECT device_id,gender,age,university,gpa from user_profile where university in (SELECT university from user_profile where university="北京大学" or univ...

Mysql

2021-11-01

1 733