Table: player_transfer
Columns: 1_january_2010
df
adam_hinshelwood
aldershot_town
wycombe_wanderers
undisclosed

Question: What are the Wycombe Wanderers when 1 January 2010 is 23 July 2009 and df is gk?
SQL: SELECT "wycombe_wanderers" FROM player_transfer WHERE "1_january_2010" = '23 July 2009' AND "df" = 'GK'

Question: What are the undisclosed when Adam Hinshelwood is Ricky Newman?
SQL: SELECT "undisclosed" FROM player_transfer WHERE "adam_hinshelwood" = 'Ricky Newman'

Question: What is the df when Adam Hinshelwood is Junior Mendes?
SQL: SELECT "df" FROM player_transfer WHERE "adam_hinshelwood" = 'Junior Mendes'

Question: What is the undisclosed when Aldertown is Aldershot Town and Wycombe Wanderers is Oxford United?
SQL: SELECT "undisclosed" FROM player_transfer WHERE "aldershot_town" = 'Aldershot Town' AND "wycombe_wanderers" = 'Oxford United'

Question: What is the undisclosed when Wycombe Wanderers is unattached?
SQL: SELECT "undisclosed" FROM player_transfer WHERE "wycombe_wanderers" = 'Unattached'