Table: hamilton_ricard
Columns: name
league
fa_cup
league_cup
total

Question: What is the average FA Cup value with a total greater than 2, a League Cup of 1, a league less than 3, and Paul Ince scoring?
SQL: SELECT AVG("fa_cup") FROM hamilton_ricard WHERE "total" > 2 AND "league_cup" = 1 AND "name" = 'paul ince' AND "league" < 3

Question: What is the average total value in a League less than 1 with more than 1 League Cup?
SQL: SELECT AVG("total") FROM hamilton_ricard WHERE "league" < 1 AND "league_cup" > 1

Question: What is the smallest value for League Cup when the League number is greater than 1, no FA Cups, and Brian Deane scoring?
SQL: SELECT MIN("league_cup") FROM hamilton_ricard WHERE "league" > 1 AND "name" = 'brian deane' AND "fa_cup" < 1