CREATE TABLE table_204_206 (id NUMBER, "saros" NUMBER, "member" NUMBER, "date" CLOB, "time\ ( greatest ) \ utc" CLOB, "type" CLOB, "location\ lat , long" CLOB, "gamma" NUMBER, "mag." NUMBER, "width\ ( km ) " NUMBER, "duration\ ( min:sec ) " CLOB, "ref" NUMBER)

how many partial members will occur before the first annular ?
SELECT COUNT("member") FROM table_204_206 WHERE "type" = 'partial' AND "date" < (SELECT MIN("date") FROM table_204_206 WHERE "type" = 'annular')
SELECT COUNT("member") FROM "table_204_206" WHERE "date" < (SELECT MIN("date") FROM "table_204_206" WHERE "type" = 'annular') AND "type" = 'partial'