Cacher is the code snippet organizer for pro developers

--深南航共飞航线
SELECT DISTINCT eline
FROM dcdb.v_tb_inport_detail t
WHERE dep_date BETWEEN '2020-04-01' AND '2020-04-30'
  AND t.air_code IN ('ZH')
  AND t.eline LIKE 'SZX%'
  AND t.up_location IN ('SZX')
  AND substr(t.flight_no, -1) BETWEEN '0' AND '9'

INTERSECT
SELECT DISTINCT eline
FROM dcdb.v_tb_inport_detail t
WHERE dep_date BETWEEN '2020-04-01' AND '2020-04-30'
  AND t.air_code IN ('CZ')
  AND t.eline LIKE 'SZX%'
  AND t.up_location IN ('SZX')
  AND substr(t.flight_no, -1) BETWEEN '0' AND '9'