CREATE TABLE table_24927 ("Name" CLOB, "Position" CLOB, "Height" CLOB, "Weight" CLOB, "Date of Birth" CLOB, "Home Team" CLOB)

If the home team is UMBC and the weight is 78kg, what the the name total number?
SELECT COUNT("Name") FROM table_24927 WHERE "Weight" = '78kg' AND "Home Team" = 'UMBC'
SELECT COUNT("Name") FROM "table_24927" WHERE "Home Team" = 'UMBC' AND "Weight" = '78kg'