CREATE TABLE table_40410 ("Volume:Issue" CLOB, "Issue Date ( s ) " CLOB, "Weeks on Top" CLOB, "Song" CLOB, "Artist" CLOB)

Which song was 1 week on top and had a volume:issue of 29:8?
SELECT "Song" FROM table_40410 WHERE "Weeks on Top" = '1' AND "Volume:Issue" = '29:8'
SELECT "Song" FROM "table_40410" WHERE "Volume:Issue" = '29:8' AND "Weeks on Top" = '1'