Table: t_1975_76_player_stats
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's the most league cup apps for Jimmy Lawson having 0 league cup goals?
SQL: SELECT MAX("league_cup_apps") FROM t_1975_76_player_stats WHERE "league_cup_goals" = 0 AND "name" = 'jimmy lawson'

Question: What's the total goals for Alan Sweeney having 0 FA Cup goals and fewer than 0 League Cup apps?
SQL: SELECT AVG("total_goals") FROM t_1975_76_player_stats WHERE "fa_cup_goals" = 0 AND "name" = 'alan sweeney' AND "league_cup_apps" < 0

Question: What's the total number of league cup apps when the league goals were less than 0?
SQL: SELECT COUNT("league_cup_apps") FROM t_1975_76_player_stats WHERE "league_goals" < 0