Untitled

user_9914919852

mysql

3 years ago

336 B

Indexable

Never

SELECT Start_Date, MIN(End_Date)
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 Start_date
ORDER BY DATEDIFF(Start_date, MIN(End_date)) DESC, Start_date