CREATE TABLE table_51690 ("Player" CLOB, "No. ( s ) " CLOB, "Height in Ft." CLOB, "Position" CLOB, "Years for Rockets" CLOB, "School/Club Team/Country" CLOB)

Which years did the Rockets number 6 play?
SELECT "Years for Rockets" FROM table_51690 WHERE "No.(s)" = '6'
SELECT "Years for Rockets" FROM "table_51690" WHERE "No.(s)" = '6'