Table: kkr_match_stats
Columns: opposition
span
lost
tied
win

Question: What is the Win % in the Span of 2011–2013 with a Lost of less than 1?
SQL: SELECT AVG("win") FROM kkr_match_stats WHERE "span" = '2011–2013' AND "lost" < 1

Question: How many games were Tied during the Span of 2011–2013 with a less than 80% Win %?
SQL: SELECT COUNT("tied") FROM kkr_match_stats WHERE "span" = '2011–2013' AND "win" < 80