How tall is player 42 from Long Beach State?
CREATE TABLE "r" (
  "player" text,
  "no_s" text,
  "height_in_ft" text,
  "position" text,
  "years_for_rockets" text,
  "school_club_team_country" text
);
SELECT "height_in_ft" FROM "r" WHERE "no_s"='42' AND "school_club_team_country"='long beach state';