Hello, is it possible to split data from one column into two, like shown in the link below?

http://sites.google.com/site/janhouse00/sql

Due to my stupidity, my last resort is to have two separate queries, one to fetch the date created, another for date closed, and dump them to some sort of array. However, I thought it can be done with one query, I have been stumbling over this issue for some time. Many thanks