Table: football_stats_8
Columns: r
player
position
the_championship
fa_cup
league_cup
total

Question: What is the R when the total is 1 and the position is fw?
SQL: SELECT "r" FROM football_stats_8 WHERE "total" = 1 AND "position" = 'FW'

Question: What is the lowest league cup?
SQL: SELECT MIN("league_cup") FROM football_stats_8

Question: What is the position for the player becchio?
SQL: SELECT "position" FROM football_stats_8 WHERE "player" = 'Becchio'

Question: How many times was the r 4?
SQL: SELECT COUNT("league_cup") FROM football_stats_8 WHERE "r" = 4