CREATE TABLE table_19730892_1 (total_apps NUMBER, name VARCHAR2)

Name the total apps for eddie carr
SELECT MAX(total_apps) FROM table_19730892_1 WHERE name = "Eddie Carr"
SELECT MAX("total_apps") FROM "table_19730892_1" WHERE "Eddie Carr" = "name"