Table: irlnrwgby
Columns: first_game
played
drawn
lost
percentage

Question: When was the earliest first game with 11 played and 12 games lost?
SQL: SELECT MIN("first_game") FROM irlnrwgby WHERE "played" > 11 AND "lost" = 12

Question: What is the average number of games played associated with a first game in 1997 and over 0 games drawn?
SQL: SELECT AVG("played") FROM irlnrwgby WHERE "first_game" = 1997 AND "drawn" > 0

Question: How many first games are associated with 5 games played and under 3 games lost?
SQL: SELECT SUM("first_game") FROM irlnrwgby WHERE "played" = 5 AND "lost" < 3

Question: How many games drawn when there are 78 losses and over 121 games played?
SQL: SELECT COUNT("drawn") FROM irlnrwgby WHERE "lost" = 78 AND "played" > 121