TSQL Beginners Challenge 5- Search the closest number in the series

The challenge is all about searching the closest number in a collection of numbers.