描述
牛客简历详细投递数据表`deliver_record_detail`如下,请你查询薪资信息不为空的职位投递记录(即最高薪资与最低薪资不全为空)
示例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', '2020-03-01') ,(102,14550, '北京'