SQL Project Planning

  • + 0 comments

    mysql solution

    select start_date, end_date 
    from 
    (select start_date, row_number() over(order by start_date) as x from projects where start_date not in (select end_date from projects)) as a  join 
    
    (select end_date, row_number() over(order by end_date) as y  from projects where end_date not in (select start_date from projects)) as b 
    on a.x = b.y
    
    order by datediff(end_date, start_date), 1