BraveCoder

分类

/ 注册

全部文章（共104篇）

题解 | 每天登陆最早的用户的内容喜好-SQL

WITH daily_earliest AS ( SELECT DATE(log_time) AS log_day, user_id, log_time, RANK() OVER (PARTITION BY DATE(log_...

2025-11-07

1 18

题解 | 统计各个部门平均薪资-SQL

select department, round(avg(normal_salary - dock_salary), 3) as avg_salary from salary_tb as a inner join staff_tb as b on a.staff_id...

2025-11-07

1 20

题解 | 二进制数1-Java

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

2025-10-21

1 29

题解 | 游游的排列构造-Java

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

2025-10-21

1 16

题解 | 更新用户积分信息？-SQL

select a.user_id, (point + add_point) as point from ( select user_id, sum(order_price) as add_point from order_tb where order_price > 1...

2025-10-20

1 27

题解 | 统计用户获得积分-SQL

SELECT user_id, SUM(diff) AS point FROM ( SELECT user_id, FLOOR( TIMESTAMPDIFF(MINUTE, vis...

2025-10-20

1 19

题解 | 统计员工薪资扣除比例-SQL

select sa.staff_id, staff_name, concat(round(dock_salary / normal_salary * 100, 1), '%') as dock_ratio from salary_tb as sa inner ...

2025-10-20

1 21

题解 | 小红的排列构造②-Java

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

2025-10-16

1 21

题解 | 构造数列-Java

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

2025-10-16

1 22

题解 | 小红的排列构造①-Java

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

2025-10-16

1 18