Order by promotion status ( startDate<getDate()<endDate )?
===

I have a table as below:

    ID    Title    StartDate    EndDate
    1     PromoA   2012-06-01   2012-08-01
    2     PromoB   2011-01-01   2011-02-01
    3     PromoC   2012-09-01   2012-10-01
    4     PromoD   2012-07-01   2012-09-01

So, there are 4 promotion with status: `1-OnGoing; 2-OutOfDate; 3-Waiting; 4-OnGoing`

How to sort them by their status?