CREATE TABLE table_47195 ("Region" CLOB, "Date" CLOB, "Label" CLOB, "Format" CLOB, "Catalog" CLOB)

Which regio has a label of zzt and a date of 27 september 2004?
SELECT "Region" FROM table_47195 WHERE "Label" = 'zzt' AND "Date" = '27 september 2004'
SELECT "Region" FROM "table_47195" WHERE "Date" = '27 september 2004' AND "Label" = 'zzt'