Table: euro_football_stats
Columns: competition
played
draw
lost
favour
against

Question: How many games did they lose when they tied less than 2 games?
SQL: SELECT "lost" FROM euro_football_stats WHERE "draw" < 2

Question: What is the least ties when they played less than 14 games, and a lost less than 8 of them?
SQL: SELECT MIN("draw") FROM euro_football_stats WHERE "played" < 14 AND "lost" < 8

Question: What is the lowest number of games played where they tied more than 7 of them?
SQL: SELECT MIN("played") FROM euro_football_stats WHERE "draw" > 7

Question: What is the highest Against where they lost less than 20 games, tied more than 2 of them, and they had Favour less than 11?
SQL: SELECT MAX("against") FROM euro_football_stats WHERE "lost" < 20 AND "draw" > 2 AND "favour" < 11