CREATE TABLE table_name_35 (loan_club VARCHAR2, name VARCHAR2)

From which club is player C. Dickinson?
SELECT loan_club FROM table_name_35 WHERE name = "c. dickinson"
SELECT "loan_club" FROM "table_name_35" WHERE "c. dickinson" = "name"