COALESCE will return the first argument that is not null, so if there is a matching news it will return the date from News and if there is no matching news but a matching tutorial it will return the date from Tutorial.

Email codedump link for Do Multiple Left Join on condition and get non null column value