Medium - Q5

 avatar
unknown
sql
4 years ago
313 B
5
Indexable
select start_date, min(end_date) from (select start_date from Projects where start_date not in (select end_date from Projects)), (select end_date from Projects where end_date not in (select start_date from Projects)) where end_date > start_date group by start_date order by min(end_date - start_date), start_date;
Editor is loading...