CREATE TABLE table_203_7 (id NUMBER, "pos." NUMBER, "artist" CLOB, "single" CLOB, "year" NUMBER, "sales" NUMBER, "peak" NUMBER)

how many artists had sales above 900,000 ?
SELECT COUNT("artist") FROM table_203_7 WHERE "sales" > 900000
SELECT COUNT("artist") FROM "table_203_7" WHERE "sales" > 900000