Agree with Jeff, but i think it would not make much difference when you have such small list of data

Refer below post:

Lead and Lag functions in SQL Server

Refer below post to understand how to display row values as a single comma separated values

Display row values as a single comma separated values

Refer below link. I think this post has exactly what you are looking for.

http://www.itdeveloperzone.com/2015/10/generating-week-dates-for-year-in-sql.html

Refer below post:

http://www.itdeveloperzone.com/2012/03/find-nth-occurrence-of-character-sql.html

Refer this link

Refer this link

Check out this link

<a href="http://itdeveloperzone.blogspot.com/2010/12/display-column-of-different-rows-as.html">Display column of different rows as column of a single row</a>