Table: doug_hayes
Columns: name
hometown
games
goals
assists
points
pen_min

Question: How many points were scored by the player with 79 goals and who played 38 games?
SQL: SELECT "points" FROM doug_hayes WHERE "goals" = '79' AND "games" = '38'

Question: How many games were played by the player with 127 assists?
SQL: SELECT "games" FROM doug_hayes WHERE "assists" = '127'

Question: How many games were played by the player who had 22 penalty minutes?
SQL: SELECT "games" FROM doug_hayes WHERE "pen_min" = '22'

Question: How many assists did the player with 54 penalty minutes have?
SQL: SELECT "assists" FROM doug_hayes WHERE "pen_min" = '54'

Question: What is John Davis's home town?
SQL: SELECT "hometown" FROM doug_hayes WHERE "name" = 'john davis'