Table: player_stats_18
Columns: name
nationality
malm_ff_career
league_appearances
league_goals
total_appearances
total_goals

Question: What is the total appearances when the total goals is 289?
SQL: SELECT MIN("total_appearances") FROM player_stats_18 WHERE "total_goals" = 289

Question: What is the league goals when the total goals is 179?
SQL: SELECT MAX("league_goals") FROM player_stats_18 WHERE "total_goals" = 179

Question: How many  total appearances are there when the league appearances is 192?
SQL: SELECT COUNT("total_appearances") FROM player_stats_18 WHERE "league_appearances" = 192