CREATE TABLE table_31021 ("Distance" CLOB, "Adelaide" CLOB, "Brisbane" CLOB, "Canberra" CLOB, "Melbourne" CLOB, "Perth" CLOB, "Sydney" CLOB)

How many listings under Melbourne has a distance at 15km?
SELECT COUNT("Melbourne") FROM table_31021 WHERE "Distance" = '15km'
SELECT COUNT("Melbourne") FROM "table_31021" WHERE "Distance" = '15km'