Table: bolton_wanderers_players
Columns: nationality
position
bolton_wanderers_career
apps
total
goals

Question: Which Bolton Wanderers career has 293 Apps?
SQL: SELECT "bolton_wanderers_career" FROM bolton_wanderers_players WHERE "apps" = 293

Question: Which Bolton Wanderers career has a Total larger than 404, and a Position of fw, and Apps less than 492, and 79 Goals?
SQL: SELECT "bolton_wanderers_career" FROM bolton_wanderers_players WHERE "total" > 404 AND "position" = 'fw' AND "apps" < 492 AND "goals" = '79'

Question: How many apps have 28 goals, and a Total smaller than 191?
SQL: SELECT SUM("apps") FROM bolton_wanderers_players WHERE "goals" = '28' AND "total" < 191