Table: notre_dame_qb_list
Columns: name
period
starts
wins
losses
ties
win

Question: Which Ties is the highest one that has Losses smaller than 9, and Starts of 26, and Wins smaller than 21?
SQL: SELECT MAX("ties") FROM notre_dame_qb_list WHERE "losses" < 9 AND "starts" = 26 AND "wins" < 21

Question: Which Win % has a Name of tony rice, and Wins smaller than 28?
SQL: SELECT COUNT("win") FROM notre_dame_qb_list WHERE "name" = 'tony rice' AND "wins" < 28

Question: Which Wins have a Win % smaller than 0.8270000000000001, and a Name of rick mirer, and Ties smaller than 1?
SQL: SELECT SUM("wins") FROM notre_dame_qb_list WHERE "win" < 0.8270000000000001 AND "name" = 'rick mirer' AND "ties" < 1

Question: How many Losses have a Name of blair kiel?
SQL: SELECT COUNT("losses") FROM notre_dame_qb_list WHERE "name" = 'blair kiel'

Question: Which Losses have a Name of jimmy clausen?
SQL: SELECT AVG("losses") FROM notre_dame_qb_list WHERE "name" = 'jimmy clausen'