JavaMaster_

题解

/ 注册

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

题解 | #统计每个学校各难度的用户平均刷题数#

select u.university, qd.difficult_level, count(q.question_id) / count(distinct q.device_id) as avg_answer_cnt from user_profile as ...

Mysql

2022-05-21

0 343

题解 | #统计每个用户的平均刷题数#

select u.university, qd.difficult_level, count(q.question_id) / count(distinct q.device_id) as avg_answer_cnt from user_profile as u...

Mysql

2022-05-21

0 353

题解 | #统计每个学校的答过题的用户的平均答题数#

select university, count(question_practice_detail.question_id) / count(distinct question_practice_detail.device_id) as avg_answer_cnt from qu...

Mysql

2022-05-20

0 378

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

select question_practice_detail.device_id, question_practice_detail.question_id, question_practice_detail.result from question_practice_d...

Mysql

2022-05-20

0 335

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

select count(gender) as male_num, sum(gpa) / count(gpa) as avg_gpa from user_profile where gender = "male"

Mysql

2022-05-19

0 387

题解 | #求小球落地5次后所经历的路程和第5次反弹的高度#

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

Java

2022-03-13

0 321

热榜题解有错

热榜第一无法解决 400+(100/5)+5这个用例，而我的可以。 import java.util.*; public class Main { public static void main(String[] args) { Scanner scan = new Sc...

Java

2022-03-12

24 1986

题解 | #整数与IP地址间的转换#

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

Java

2022-03-11

0 311

题解 | #字符串加密#

和题目有所不同, 下面的代码. 支持大小写都存在的用例. import java.util.*; public class Main { public static void main(String[] args) { Scanner scan = new Scanner(S...

Java

2022-03-09

0 394

题解 | #密码截取#

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

Java 字符串

2022-03-09

0 489