CREATE TABLE table_204_15 (id NUMBER, "year" NUMBER, "date" CLOB, "venue" CLOB, "city" CLOB, "country" CLOB, "notes" CLOB)

in the chart is nara before firenze ?
SELECT (SELECT id FROM table_204_15 WHERE "city" = 'nara') < (SELECT id FROM table_204_15 WHERE "city" = 'firenze')
SELECT (SELECT "id" FROM "table_204_15" WHERE "city" = 'firenze') > (SELECT "id" FROM "table_204_15" WHERE "city" = 'nara')