CREATE TABLE table_79673 ("Rank" FLOAT, "Name" CLOB, "Tenure" CLOB, "Leagues" CLOB, "Attempts" FLOAT, "Completions" FLOAT, "Comp %" FLOAT, "Touchdowns" FLOAT, "Interceptions" FLOAT, "Yardage" FLOAT, "QB Rating" FLOAT)

What is the comp percentage when there are less than 44,611 in yardage, more than 254 touchdowns, and rank larger than 24?
SELECT MIN("Comp %") FROM table_79673 WHERE "Yardage" < '44,611' AND "Touchdowns" > '254' AND "Rank" > '24'
SELECT MIN("Comp %") FROM "table_79673" WHERE "Rank" > '24' AND "Touchdowns" > '254' AND "Yardage" < '44,611'