跪求要一个offer

题解

/ 注册

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

题解 | #计算商场折扣#

import java.util.*; public class Main { public static void main(String[] args) { Scanner console = new Scanner(System.in); int price = console.nextInt...

Java

2021-11-02

0 301

题解 | #交换变量值#

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

Java

2021-11-02

0 311

题解 | #四舍五入#

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 516

题解 | #类型转换#

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 421

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

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 328

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

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 306

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

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 343

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

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 307

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

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 248