CREATE TABLE table_203_538 (id NUMBER, "flight" CLOB, "date" CLOB, "payload nickname" CLOB, "payload" CLOB, "orbit" CLOB, "result" CLOB)

how many partial failures of h ii flights were there ?
SELECT COUNT(*) FROM table_203_538 WHERE "result" = 'partial failure'
SELECT COUNT(*) FROM "table_203_538" WHERE "result" = 'partial failure'