Untitled
unknown
plain_text
4 years ago
389 B
7
Indexable
SELECT START_DATE, X FROM (
SELECT A.START_DATE, MIN(B.END_DATE) AS X
FROM
(SELECT START_DATE FROM PROJECTS WHERE START_DATE NOT IN (SELECT END_DATE FROM PROJECTS)) A,
(SELECT END_DATE FROM PROJECTS WHERE END_DATE NOT IN (SELECT START_DATE FROM PROJECTS)) B
WHERE START_DATE < END_DATE
GROUP BY A.START_DATE
) P
ORDER BY DATEDIFF(X, START_DATE), START_DATE;Editor is loading...