CREATE TABLE table_204_185 (id NUMBER, "location" CLOB, "town" CLOB, "output  ( mw ac ) " NUMBER, "modules" NUMBER, "number of arrays" NUMBER)

how many arrays are not in hauppauge ?
SELECT SUM("number of arrays") FROM table_204_185 WHERE "town" <> 'hauppauge'
SELECT SUM("number of arrays") FROM "table_204_185" WHERE "town" <> 'hauppauge'