Table: bohemians_shamrock_rovers_games
Columns: season
date
home_team
result
away_team
stadium

Question: Who as the home team for game on 5 october 2011?
SQL: SELECT "home_team" FROM bohemians_shamrock_rovers_games WHERE "date" = '5 October 2011'

Question: What was the stadium for the home team of shamrock rovers and result of 3–0?
SQL: SELECT "stadium" FROM bohemians_shamrock_rovers_games WHERE "home_team" = 'Shamrock Rovers' AND "result" = '3–0'

Question: What was the away team when the result was 2–1 and home team was the bohemians?
SQL: SELECT "away_team" FROM bohemians_shamrock_rovers_games WHERE "result" = '2–1' AND "home_team" = 'Bohemians'

Question: Who was the home team for the 2013 season and the result was 0–0?
SQL: SELECT "home_team" FROM bohemians_shamrock_rovers_games WHERE "season" = '2013' AND "result" = '0–0'

Question: What is the date for the game at the tallaght stadium and result was 0–1?
SQL: SELECT "date" FROM bohemians_shamrock_rovers_games WHERE "stadium" = 'Tallaght Stadium' AND "result" = '0–1'