Presidential - Released March 2005 1. George Washington 2. John Adams 3. Thomas Jefferson 4. James Madison 5. James Monroe 6. John Quincy Adams 7. Andrew Jackson 8. Martin Van Buren 9. William Henry Harrison 10. John Tyler 11. James K Polk 12. Zachary Taylor 13. Millard Fillmore 14. Franklin Pierce 15. James Buchanan 16. Abraham Lincoln 17. Andrew Johnson 18. Ulysses Grant 19. Rutherford B Hayes 20. James Garfield 21. Chester Arthur 22. Grover Cleveland 23. Benjamin Harrison 24. Grover Cleveland 25. William Mckinley 26. Theodore Roosevelt 27. William Howard Taft 28. Woodrow Wilson 29. Warren Harding 30. Calvin Coolidge 31. Herbert Hoover 32. Fdr 33. Harry Truman 34. Dwight Eisenhower 35. Jfk 36. Lyndon Johnson 37. Richard Milhous Nixon 38. Gerald Ford 39. Jimmy Carter 40. Ronald Reagan 41. George H W Bush 42. Bill Clinton 43. George W Bush

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 = 'presidential' and b.albumid = a.albumid order by b.tracknumber