Table: oldest_football_comps
Columns: years
type
original_code
current_code
location

Question: What is the current code for the club trophy, in 1867 only?
SQL: SELECT "current_code" FROM oldest_football_comps WHERE "type" = 'club trophy' AND "years" = '1867 only'

Question: What is the location of the original code for victorian rules?
SQL: SELECT "location" FROM oldest_football_comps WHERE "original_code" = 'victorian rules'

Question: What is the location for the club trophy?
SQL: SELECT "location" FROM oldest_football_comps WHERE "type" = 'club trophy'

Question: What is the location for the club trophy from the year 1867 only?
SQL: SELECT "location" FROM oldest_football_comps WHERE "type" = 'club trophy' AND "years" = '1867 only'