Table: roster_history
Columns: player
no_s
height_in_ft
position
years_for_rockets
school_club_team_country

Question: What is the height in ft for the rockets from 1973-78?
SQL: SELECT "height_in_ft" FROM roster_history WHERE "years_for_rockets" = '1973-78'

Question: Which players were number 3?
SQL: SELECT "player" FROM roster_history WHERE "no_s" = '3'

Question: What is the height in ft for number 42 for the rockets in 1993-94?
SQL: SELECT "height_in_ft" FROM roster_history WHERE "no_s" = '42' AND "years_for_rockets" = '1993-94'

Question: What are the players that attented long beach state?
SQL: SELECT "player" FROM roster_history WHERE "school_club_team_country" = 'Long Beach State'

Question: what is the total amount of players for the rockets in 1998 only?
SQL: SELECT COUNT("player") FROM roster_history WHERE "years_for_rockets" = '1998'