Table: loftus_road_football
Columns: date
sport
winner
score
loser

Question: Who was the winner in 2007?
SQL: SELECT "winner" FROM loftus_road_football WHERE "date" = 2007

Question: What sport was played before 2006 with a loser of france b?
SQL: SELECT "sport" FROM loftus_road_football WHERE "date" < 2006 AND "loser" = 'france b'

Question: Who was the winner with the loser being russia-2?
SQL: SELECT "winner" FROM loftus_road_football WHERE "loser" = 'russia-2'

Question: Who was the loser playing football with england b as a winner after 1992?
SQL: SELECT "loser" FROM loftus_road_football WHERE "sport" = 'football' AND "winner" = 'england b' AND "date" > 1992