Table: rookies_roster
Columns: player
no_s
height_in_ft
position
years_for_rockets
school_club_team_country

Question: What player attended Loyola Marymount?
SQL: SELECT "player" FROM rookies_roster WHERE "school_club_team_country" = 'Loyola Marymount'

Question: How may times did a player that attended Iowa state appear on the all time roster?
SQL: SELECT COUNT("years_for_rockets") FROM rookies_roster WHERE "school_club_team_country" = 'Iowa State'

Question: What height was the player that played for the Rockets between 1992-93?
SQL: SELECT "height_in_ft" FROM rookies_roster WHERE "years_for_rockets" = '1992-93'

Question: How many times did a center that attended Oral Roberts play for the Rockets?
SQL: SELECT COUNT("years_for_rockets") FROM rookies_roster WHERE "position" = 'Center' AND "school_club_team_country" = 'Oral Roberts'

Question: What was the player name who came from Australia?
SQL: SELECT "player" FROM rookies_roster WHERE "school_club_team_country" = 'Australia'