CREATE TABLE table_7142 ("RANK" FLOAT, "NAME" CLOB, "TEAM" CLOB, "COUNTRY" CLOB, "POINTS" FLOAT)

What rank was Peter Schmeichel?
SELECT SUM("RANK") FROM table_7142 WHERE "NAME" = 'peter schmeichel'
SELECT SUM("RANK") FROM "table_7142" WHERE "NAME" = 'peter schmeichel'