예시 자료엔 종료일시가 시작일시와 항상 연결되는데?
혹시 연속되지 않고 끊기는 자료는 없는지?
항상 연결된다면? 순서만 가지고 쿼리 구현이 가능하지만
끊기는 구간까지 감안해야 한다면? 연속/비연속 체크 로직이 한번 더 들어가야 합니다.
DBMS 및 버전에 따라 구현방법이 달라질 수 있습니다.
DBMS 및 버전 표시해 주세요.

WITH t AS
(
SELECT '2019-10-30 06:30' start_date, '2019-10-30 06:40' end_date, '이동' loc  FROM dual
UNION ALL SELECT '2019-10-30 06:40', '2019-10-30 06:50', '이동'  FROM dual
UNION ALL SELECT '2019-10-30 06:50', '2019-10-30 07:00', '이동'  FROM dual
UNION ALL SELECT '2019-10-30 07:00', '2019-10-30 07:10', 'Zone9' FROM dual
UNION ALL SELECT '2019-10-30 07:10', '2019-10-30 07:20', '이동'  FROM dual
UNION ALL SELECT '2019-10-30 07:20', '2019-10-30 07:30', 'Zone6' FROM dual
UNION ALL SELECT '2019-10-30 07:30', '2019-10-30 07:40', 'Zone6' FROM dual
UNION ALL SELECT '2019-10-30 07:40', '2019-10-30 07:50', 'Zone4' FROM dual
UNION ALL SELECT '2019-10-30 07:50', '2019-10-30 08:00', 'Zone6' FROM dual
UNION ALL SELECT '2019-10-30 08:00', '2019-10-30 08:10', '이동'  FROM dual
UNION ALL SELECT '2019-10-30 08:10', '2019-10-30 08:20', '이동'  FROM dual
)
SELECT MIN(start_date) start_date
     , MAX(end_date  ) end_date  
     , loc
  FROM (SELECT start_date, end_date, loc
             , ROW_NUMBER() OVER(ORDER BY start_date)
             - ROW_NUMBER() OVER(PARTITION BY loc ORDER BY start_date) gb
          FROM t
        )
 GROUP BY loc, gb
 ORDER BY start_date
;