Table: player_stats_91
Columns: name
position
league_apps
league_goals
fa_cup_apps
fa_cup_goals
league_cup_apps
league_cup_goals
total_apps
total_goals

Question: What are the total apps that have 41 as the League apps, with total goals greater than 1?
SQL: SELECT "total_apps" FROM player_stats_91 WHERE "league_apps" = '41' AND "total_goals" > 1

Question: What are the average league goals that have 2 (1) as the total apps?
SQL: SELECT AVG("league_goals") FROM player_stats_91 WHERE "total_apps" = '2 (1)'

Question: What is the highest league goals that have barry endean as the name, wirh FA cup apps greater than 0?
SQL: SELECT MAX("league_goals") FROM player_stats_91 WHERE "name" = 'barry endean' AND "fa_cup_apps" > 0