CREATE TABLE table_204_765 (id NUMBER, "year" NUMBER, "location" CLOB, "gold" CLOB, "silver" CLOB, "bronze" CLOB)

how many singles competitions have been played in bangkok ?
SELECT COUNT(*) FROM table_204_765 WHERE "location" = 'bangkok'
SELECT COUNT(*) FROM "table_204_765" WHERE "location" = 'bangkok'