การตรวจสอบข้อมูลแบบต่อเนื่อง มันสามารถตรวจสอบได้หรือเปล่าครับ

CREATE TABLE `datetimecontinuous` (
  `id` int(11) NOT NULL,
  `date` datetime DEFAULT NULL,
  `time` time DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `datetimecontinuous` (`id`, `date`, `time`) VALUES
(1, '2021-02-27 22:14:17', '07:00:00'),
(2, '2021-02-27 22:14:21', '09:00:00'),
(3, '2021-02-27 22:14:55', '10:00:00'),
(4, '2021-02-27 22:14:58', '11:00:00'),
(5, '2021-02-27 22:15:19', '15:00:00'),
(6, '2021-02-27 22:15:25', '17:00:00'),
(7, '2021-02-27 22:27:14', '18:00:00'),
(8, '2021-02-27 22:27:16', '19:00:00'),
(9, '2021-02-27 22:27:19', '22:00:00'),
(10, '2021-02-27 22:27:21', '23:00:00');

SELECT `dtc`.`time` AS `dtc1_time`, `dtc2`.`time` AS `dtc2_time`
FROM `datetimecontinuous` AS `dtc`
JOIN `datetimecontinuous` AS `dtc2`
ON `dtc2`.`time` = TIMESTAMPADD(HOUR, 1, `dtc`.`time`)