Table: psg_players
Columns: name
position
period
appearances
goals
nationality

Question: How many games had less than 7 goals scored?
SQL: SELECT COUNT("appearances") FROM psg_players WHERE "goals" = 7

Question: List the player that scored 4 times.
SQL: SELECT "name" FROM psg_players WHERE "goals" = 4

Question: How many players are from the country of Brazil?
SQL: SELECT COUNT("position") FROM psg_players WHERE "nationality" = 'Brazil'

Question: List the number of active years for attaquant.
SQL: SELECT "period" FROM psg_players WHERE "position" = 'Attaquant'