Album of the Decade - Released January 2010 1. The Man With The City In His Teeth 2. Deans of Pop 3. Community College Is Not For Everyone 4. You Weren't Last Year's Decade 5. Classics To Rival The Classics 6. Poor Man's Haircut 7. Buick Century Olympic Edition 8. It's Hard To Mix Shannon 9. Down There 10. Small Jobs 11. House Calls 12. Presbyterian Ladies College

select *, DATENAME ( month , A.date_started ) as datestartedMM, DATENAME ( year , A.date_started ) as datestartedYY, DATENAME ( month , A.date_completed ) as datecompletedMM, DATENAME ( year , A.date_completed ) as datecompletedYY from albums a, songs b where a.foldername = 'albumofthedecade' and b.albumid = a.albumid order by b.tracknumber