CREATE TABLE table_204_642 (id NUMBER, "team" CLOB, "domestic tournament" CLOB, "position" CLOB, "appearance" CLOB, "qualified" CLOB)

the auckland aces and yorkshire carnegie qualified on what date ?
SELECT "qualified" FROM table_204_642 WHERE "team" = 'auckland aces'
SELECT "qualified" FROM "table_204_642" WHERE "team" = 'auckland aces'