Table: fc_halifax_stats
Columns: year
league
position
leading_scorer
fa_cup
fa_trophy

Question: what is the league when the fa cup is qr4 and the fa trophy is qf?
SQL: SELECT "league" FROM fc_halifax_stats WHERE "fa_cup" = 'qr4' AND "fa_trophy" = 'qf'

Question: what is the fa trophy when the leading scorer is lee gregory (8)?
SQL: SELECT "fa_trophy" FROM fc_halifax_stats WHERE "leading_scorer" = 'lee gregory (8)'

Question: what is the year when the position is 1/22 promoted and the leading scorer is james dean (27)?
SQL: SELECT "year" FROM fc_halifax_stats WHERE "position" = '1/22 promoted' AND "leading_scorer" = 'james dean (27)'