CREATE TABLE table_55735 ("State" CLOB, "Interview" FLOAT, "Swimsuit" FLOAT, "Evening gown" FLOAT, "Average" FLOAT)

What's the highest swimsuit for an average less than 8.073, evening gown less than 8.31, and an interview over 8.23 in georgia?
SELECT MAX("Swimsuit") FROM table_55735 WHERE "Average" < '8.073' AND "Evening gown" < '8.31' AND "Interview" > '8.23' AND "State" = 'georgia'
SELECT MAX("Swimsuit") FROM "table_55735" WHERE "Average" < '8.073' AND "Evening gown" < '8.31' AND "Interview" > '8.23' AND "State" = 'georgia'