Table: t_1940_vfl_lightning
Columns: home_team
home_team_score
away_team
away_team_score
ground
date

Question: How many home teams are there when the away team score was 4.2 (26) and away team was footscray?
SQL: SELECT COUNT("home_team_score") FROM t_1940_vfl_lightning WHERE "away_team_score" = '4.2 (26)' AND "away_team" = 'Footscray'

Question: Which team was the away team when home team was essendon?
SQL: SELECT "away_team" FROM t_1940_vfl_lightning WHERE "home_team" = 'Essendon'

Question: How many scores were there for the home team when the  away team was fitzroy?
SQL: SELECT COUNT("home_team_score") FROM t_1940_vfl_lightning WHERE "away_team" = 'Fitzroy'

Question: Which team was the away team when the home team was north melbourne?
SQL: SELECT "away_team" FROM t_1940_vfl_lightning WHERE "home_team" = 'North Melbourne'

Question: What is the date of the game when the home team is melbourne?
SQL: SELECT "date" FROM t_1940_vfl_lightning WHERE "home_team" = 'Melbourne'

Question: What is the date when the  home team score is 2.4 (16)?
SQL: SELECT "date" FROM t_1940_vfl_lightning WHERE "home_team_score" = '2.4 (16)'