Table: notre_dame_qb_stats
Columns: quarterback
jersey_no
games_started
wins
losses
ties
winning_pct

Question: How many ties were there for game 36 started?
SQL: SELECT COUNT("ties") FROM notre_dame_qb_stats WHERE "games_started" = 36

Question: What is the winning pct for jersey 15?
SQL: SELECT "winning_pct" FROM notre_dame_qb_stats WHERE "jersey_no" = '15'

Question: Who is the quarter back for a winning pct of .792
SQL: SELECT "quarterback" FROM notre_dame_qb_stats WHERE "winning_pct" = '.792'

Question: How many lost games for jersey number 2 and games started is less than 7.0?
SQL: SELECT "losses" FROM notre_dame_qb_stats WHERE "jersey_no" = '2' AND "games_started" < 7.0