CREATE TABLE table_name_26 (pick__number NUMBER, team_from VARCHAR2)

What pick # has a team from Rimouski Oc anic?
SELECT AVG(pick__number) FROM table_name_26 WHERE team_from = "rimouski océanic"
SELECT AVG("pick__number") FROM "table_name_26" WHERE "rimouski océanic" = "team_from"