SQL. Select - работа с диапазонами

Практика:
- диапазоны и конструкция исключений значений;
SELECT * FROM CHANNEL_DETAILS
WHERE CCID IN (4431,913,4336)
AND CH_START NOT IN (
SELECT CH_START FROM CHANNEL_DETAILS WHERE CH_START>='19.08.14')
AND
CH_END NOT IN (SELECT CH_END FROM CHANNEL_DETAILS WHERE CH_END<='19.05.14')
AND ((CHANNEL_STATE='ACT') OR (CHANNEL_STATE='RDY') OR (CHANNEL_STATE='NEW'));


Теория: