程序员Realeo

分类

/ 注册

全部文章（共161篇）

题解 | #单组_spj判断数组之和#

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

2024-10-08

0 125

题解 | #单组_二维字符数组#

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

2024-10-08

0 152

题解 | #每个月Top3的周杰伦歌曲#

select * from ( select fdate as month, row_number() over ( partition by fd...

2024-09-27

0 142

题解 | #分析客户逾期情况#

select pay_ability as pay_ability, concat (round(count(overdue_days) / count(1) * 100, 1), "%") as overdue_ratio from loan_tb l,...

2024-09-26

0 173

题解 | #统计各岗位员工平均工作时长#

select s.post as post, round(avg(timestampdiff(second,first_clockin,last_clockin ) / 3600),3) as work_hours from staff_tb s, attendent...

2024-09-25

0 140

题解 | #每个商品的销售总额#

select product_name, total_sales, row_number() over ( partition by category ) as category_rank from ( ...

2024-09-25

0 97

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

select round(avg(score), 3) avg_score from user_action_tb where (user_id, hobby_l) in ( select rec_user user_id, ...

2024-09-25

1 162

题解 | #查询培训指定课程的员工信息#

select c.staff_id as staff_id, s.staff_name as staff_name from cultivate_tb c,staff_tb s where c.staff_id = s.staff_id and c.cour...

2024-09-25

0 114

题解 | #统计所有课程参加培训人次#

select sum( length (course) - length (replace (course, ',', '')) + 1 ) as staff_nums from cultivate_tb

2024-09-25

0 106

题解 | #查询连续入住多晚的客户信息？#

select c.user_id as user_id, c.room_id as room_id, g.room_type as room_type, day(c.checkout_time) - day(c.checkin_time) as days from ...

2024-09-25

0 85