牛客519743588号

分类

/ 注册

全部文章（共22篇）

题解 | 推荐内容准确的用户平均评分

select round(avg(distinct score),3) as avg_score from recommend_tb rt join user_action_tb ut on rt.rec_user=ut.user_id where rt.rec_info_l=ut.hobby_l...

2025-09-18

0 17

题解 | 最大最小值

import java.util.Scanner; // 注意类名必须为 Main, 不要有任何 package xxx 信息 public class Main { public static void main(String[] args) { Scanner in =...

2025-09-17

0 17

题解 | 获取指定客户每月的消费额

select concat(year(t.t_time),case when month(t.t_time) < 10 then '-0' else '-' end,month(t.t_time)) as time,sum(t.t_amount) as total from trade t j...

2025-09-17

0 18

题解 | 明天星期几？

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

2025-09-16

0 13

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

select qd.difficult_level, sum(case when qpd.result='right' then 1 else 0 end)/count(qpd.question_id) as correct_rate from user_profile up join quest...

2025-09-16

0 16

题解 | 绕距

import java.util.Scanner; // 注意类名必须为 Main, 不要有任何 package xxx 信息 public class Main { public static void main(String[] args) { Scanner in =...

2025-09-15

0 15

题解 | 温标转换

import java.util.Scanner; // 注意类名必须为 Main, 不要有任何 package xxx 信息 public class Main { public static void main(String[] args) { Scanner in =...

2025-09-15

0 18

题解 | 反向输出一个四位数

import java.util.Scanner;// 注意类名必须为 Main, 不要有任何 package xxx 信息public class Main {public static void main(String[] args) {Scanner in = new Scanner(Syst...

2025-09-15

0 20

题解 | 截取出年龄

select substring_index(substring_index(profile,',',-2),',',1) as age, count(*) as number from user_submit group by age order by age desc;

2025-09-15

0 16

题解 | 提取博客URL中的用户名

select device_id,substring_index(blog_url,'/',-1) as user_name from user_submit;

2025-09-15

0 12