CREATE TABLE table_204_570 (id NUMBER, "rank" NUMBER, "mountain" CLOB, "height  ( m ) " NUMBER, "height  ( ft ) " NUMBER, "range" CLOB, "coordinates" CLOB, "prominence  ( m ) " NUMBER, "parent mountain" CLOB, "first ascent" NUMBER, "ascents  ( failed attempts )  bef.2004" CLOB)

how many mountains have a height higher than 8,000 meters ?
SELECT COUNT("mountain") FROM table_204_570 WHERE "height (m)" > 8000
SELECT COUNT("mountain") FROM "table_204_570" WHERE "height (m)" > 8000