Table: us_national_hockey_players_4
Columns: position
name
height_cm
weight_kg
birthdate
birthplace
1997_1998_team

Question: What is the average Height when the weight is less than 91 and the position is d, and a Birthdate of july 4, 1975?
SQL: SELECT AVG("height_cm") FROM us_national_hockey_players_4 WHERE "weight_kg" < 91 AND "position" = 'd' AND "birthdate" = 'july 4, 1975'

Question: What is the sum of Weight for the person born in virginia, minnesota?
SQL: SELECT SUM("weight_kg") FROM us_national_hockey_players_4 WHERE "birthplace" = 'virginia, minnesota'

Question: What is the Name with a height of more than 183 cm for the 1997–1998 Team of mighty ducks of anaheim?
SQL: SELECT "name" FROM us_national_hockey_players_4 WHERE "height_cm" > 183 AND "1997_1998_team" = 'mighty ducks of anaheim'

Question: What is the Birthdate for the person with a height less than 191, and weight of 84 kg?
SQL: SELECT "birthdate" FROM us_national_hockey_players_4 WHERE "height_cm" < 191 AND "weight_kg" = 84

Question: What is the Position with a height of less than 183, and a weight of less than 91 kg and born in bloomington, minnesota?
SQL: SELECT "position" FROM us_national_hockey_players_4 WHERE "height_cm" < 183 AND "weight_kg" < 91 AND "birthplace" = 'bloomington, minnesota'