Table: psg_players_8
Columns: name
position
period
appearances
goals
nationality

Question: What is the highest number of goals scored
SQL: SELECT MAX("goals") FROM psg_players_8

Question: What is the lowest number of appearances a player had
SQL: SELECT MIN("appearances") FROM psg_players_8

Question: What is the nationality of Louis floch
SQL: SELECT "nationality" FROM psg_players_8 WHERE "name" = 'Louis Floch'

Question: Which player had 252 appearances
SQL: SELECT "name" FROM psg_players_8 WHERE "appearances" = 252

Question: What is the nationality of the player who scored 13 goals
SQL: SELECT "nationality" FROM psg_players_8 WHERE "goals" = 13