希望被offer砸中的红太狼很精致

分类

/ 注册

全部文章（共17篇）

题解 | #得分不小于平均分的最低分#

select min(a.score) from exam_record a,examination_info b where a.exam_id=b.exam_id and b.tag='SQL' and a.score is not null and a.score>=(select su...

2023-08-04

0 208

题解 | #SQL类别高难度试卷得分的截断平均值#

select tag,difficulty,round((sum(b.score)-max(b.score)-min(b.score))/(count(b.score)-2),1) as clip_avg_score from examination_info a,exam_record b whe...

2023-08-04

0 348

题解 | #map简单应用#

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

2023-07-20

0 395

题解 | #回文数判断#

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

2023-07-19

0 342

题解 | #记录点赞用户#

import java.util.*; public class Main { public static void main(String[] args) { LikeRecorder recorder = new LikeRecorderImpl(); ...

2023-07-19

1 403

题解 | #编写个人所得税计算程序#

import java.util.*; public class Main { public static void main(String[] args) { List<Employee> employees = new ArrayList<>()...

2023-07-18

0 595

题解 | #创建一张新表#

drop table if EXISTS user_info_vip; CREATE TABLE IF NOT EXISTS user_info_vip ( id int PRIMARY KEY AUTO_INCREMENT COMMENT '自增ID', uid int(11) unique NO...

2023-07-09

0 363

题解 | #删除记录（二）#

delete from exam_record where submit_time is null or TIME_TO_SEC(TIMEDIFF(submit_time,start_time))/60<5 order by start_time limit 3

2023-07-08

0 249

题解 | #删除记录（一）#

delete from exam_record where TIME_TO_SEC(TIMEDIFF(submit_time,start_time)) / 60 <5 and score<60

2023-07-08

0 325

题解 | #插入记录（一）#

insert into exam_record (id,uid, exam_id, start_time, submit_time, score) values (null,'1001','9001','2021-09-01 22:11:12','2021-09-01 23:01:12','90...

2023-07-08

0 258