Table: brian_mcbride
Columns: name
league
fa_cup
league_cup
total

Question: what is the lowest total when the league cup is more than 0, the name is heiðar helguson and the league is less than 3?
SQL: SELECT MIN("total") FROM brian_mcbride WHERE "league_cup" > 0 AND "name" = 'heiðar helguson' AND "league" < 3

Question: what is the highest fa cup when the league cup is more than 0, the name is heiðar helguson and the league is less than 3?
SQL: SELECT MAX("fa_cup") FROM brian_mcbride WHERE "league_cup" > 0 AND "name" = 'heiðar helguson' AND "league" < 3

Question: what is the total when the league is less than 1?
SQL: SELECT "total" FROM brian_mcbride WHERE "league" < 1