CREATE TABLE table_2679061_7 (college_junior_club_team VARCHAR2, nhl_team VARCHAR2)

Where are the Buffalo Sabres from?
SELECT college_junior_club_team FROM table_2679061_7 WHERE nhl_team = "Buffalo Sabres"
SELECT "college_junior_club_team" FROM "table_2679061_7" WHERE "Buffalo Sabres" = "nhl_team"