Table: us_national_hockey_players_10
Columns: position
jersey
name
height_cm
weight_kg
birthdate
birthplace
1986_1987_team

Question: What is the height of the player born on June 24, 1964, with a weight over 84 kg?
SQL: SELECT AVG("height_cm") FROM us_national_hockey_players_10 WHERE "weight_kg" > 84 AND "birthdate" = 'june 24, 1964'

Question: On what date was the player from Melrose, Massachusetts born?
SQL: SELECT "birthdate" FROM us_national_hockey_players_10 WHERE "birthplace" = 'melrose, massachusetts'

Question: What is the height of the player from the Washington Capitals, who was born in Detroit, Michigan and has a jersey number under #11?
SQL: SELECT MIN("height_cm") FROM us_national_hockey_players_10 WHERE "1986_1987_team" = 'washington capitals' AND "birthplace" = 'detroit, michigan' AND "jersey" < 11