Table: gene_hassell_stats
Columns: year
team
league
record
finish
organization

Question: Which finish has a Record of 74-68?
SQL: SELECT "finish" FROM gene_hassell_stats WHERE "record" = '74-68'

Question: What is the total of the year with a Team of johnson city yankees, and a Finish of 6th?
SQL: SELECT SUM("year") FROM gene_hassell_stats WHERE "team" = 'johnson city yankees' AND "finish" = '6th'

Question: Which record has a Team of manchester yankees?
SQL: SELECT "record" FROM gene_hassell_stats WHERE "team" = 'manchester yankees'

Question: Which organization has a Finish of 4th?
SQL: SELECT "organization" FROM gene_hassell_stats WHERE "finish" = '4th'

Question: Which year has an Organization of new york yankees, and a Team of johnson city yankees?
SQL: SELECT "year" FROM gene_hassell_stats WHERE "organization" = 'new york yankees' AND "team" = 'johnson city yankees'