胖橘不乖

分类

题解(26)

/ 注册

全部文章（共22篇）

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

select university,difficult_level, round(count(q.question_id) / count(distinct u.device_id),4) from question_practice_detail q left join user_pr...

Mysql

2022-04-23

0 272

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

select u.university,convert(count(question_id) / count(distinct u.device_id),decimal(10,4)) from user_profile u inner join question_...

Mysql

2022-04-22

0 248

题解 | #寻找峰值#

import java.util.*; public class Solution { /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * ...

Java 二分查找

2022-04-18

0 362

题解 | #二维数组中的查找#

public class Solution { public boolean Find(int target, int [][] array) { int n = array.length...

Java 二分查找

2022-04-18

0 222

题解 | #把数字翻译成字符串#

import java.util.*; public class Solution { /** * 解码 * @param nums string字符串数字串 ...

Java 动态规划

2022-04-17

0 288

题解 | #链表中的节点每k个一组翻转#

import java.util.*; /* * public class ListNode { * int val; * ListNode next = null; * } */ pub...

Java 递归

2022-04-17

0 176

题解 | #链表中的节点每k个一组翻转#

import java.util.*; /* public class ListNode { int val; ListNode next = null; } */ public class Solution { /** * * @param head ListNode类 * @param k ...

Java 递归

2022-04-17

0 283

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

select u.device_id, q.question_id,q.result from user_profile u inner join question_practice_detail q on u.device_id = q.device_id where u.university =...

Mysql

2022-04-17

0 255

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

select device_id,question_id,result from question_practice_detail where device_id in (select device_id from user_profile where university = '浙江大学');

Mysql

2022-04-16

0 197

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

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

Mysql

2022-04-16

0 206