描述
牛客简历详细投递数据表`deliver_record_detail`如下,查询投递简历中最低薪资(min_salary)与最高薪资(max_salary)差别大于2的职位的投递用户user_id
示例1
输入:
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', '20