CREATE TABLE table_54123 ("Player" CLOB, "Car." FLOAT, "Yards" FLOAT, "Avg." FLOAT, "TD's" FLOAT, "Long" FLOAT)

How many TDs for the player with a long of less than 4 and under 8 yards?
SELECT SUM("TD's") FROM table_54123 WHERE "Long" < '4' AND "Yards" < '8'
SELECT SUM("TD's") FROM "table_54123" WHERE "Long" < '4' AND "Yards" < '8'