SQL : VQ6 查询投递最低最高薪资差别大于2的职位的投递用户user_id

题目 : https://www.nowcoder.com/practice/88b3cd0bde4141dfbfa79c3dec44fd9a?tpId=341

数据

drop table if exists deliver_record_detail;

CREATE TABLE `deliver_record_detail` (
  `user_id` int NOT NULL,
  `job_id` int NOT NULL,
  `job_city` varchar(64) NOT NULL,
  `device` varchar(14) NOT NULL,
  `min_salary` int ,
  `max_salary` int,
  `deliver_date` date  NOT NULL
);

INSERT INTO deliver_record_detail VALUES
(101,14550, '上海','app','18','20', '2020-03-01')
,(102,14550, '北京','pc','10','15','2021-07-07')
,(103,23654, '北京','pc','12',null, '2021-04-09')
,(102,23152, '杭州','app','25','30','2022-03-17')
,(105,75432, '厦门','pc','30','60', '2016-08-15')
,(204,49642, '北京市','pc', null, null, '2019-05-15');

需求

查询投递简历中最低薪资（min_salary）与最高薪资（max_salary）差别大于2的职位的投递用户 user_id

查询结果 :

user_id
102
102
105

解决

• 对最大值 - 最小值 , 求差值 , 比较 2

select user_id
from deliver_record_detail
where (max_salary - min_salary) > 2