good start of the day with +1..
first did R&D about coalesce thn attempt the question and select correct answer 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/