Table: rookies_players_3
Columns: player
no_s
height_in_ft
position
years_for_rockets
school_club_team_country

Question: Who is the player for St. Mary's team?
SQL: SELECT "player" FROM rookies_players_3 WHERE "school_club_team_country" = 'st. mary''s'

Question: How tall is the player from Mississippi
SQL: SELECT "height_in_ft" FROM rookies_players_3 WHERE "school_club_team_country" = 'mississippi'

Question: What is the player number for the player from Centenary?
SQL: SELECT "no_s" FROM rookies_players_3 WHERE "school_club_team_country" = 'centenary'

Question: How tall is player 42 from Long Beach State?
SQL: SELECT "height_in_ft" FROM rookies_players_3 WHERE "no_s" = '42' AND "school_club_team_country" = 'long beach state'