CREATE TABLE table_37006 ("Player" CLOB, "Sacks" FLOAT, "INT'S" FLOAT, "Yards" FLOAT, "Average" FLOAT, "Long" CLOB)

What are the most yards for 2 sacks and an average greater than 0?
SELECT MAX("Yards") FROM table_37006 WHERE "Sacks" = '2' AND "Average" > '0'
SELECT MAX("Yards") FROM "table_37006" WHERE "Average" > '0' AND "Sacks" = '2'