牛客-SQL篇-SQL基础进阶-02数据过滤-数据过滤-VQ5查询在pc上投递的所有投递记录

描述

牛客简历详细投递数据表`deliver_record_detail`如下，请你查询在pc上投递的所有投递记录

示例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, '北京','pc','10','15','2021-07-07')
,(103,23654, '北京','pc','12',null, '2021-04-09')
,(102,23152, '杭州','app','25','30','2022-03-17')
,