Table: footballers
Columns: ranking
nationality
name
years
goals

Question: Who was from Morocco and scored 6 goals?
SQL: SELECT "name" FROM footballers WHERE "goals" = 6 AND "nationality" = 'morocco'

Question: Who has the highest ranking from  1996–13, and more than 17 goals?
SQL: SELECT MAX("ranking") FROM footballers WHERE "years" = '1996–13' AND "goals" > 17

Question: What was the average ranking of Saudi Arabia in the years of 2000–?
SQL: SELECT AVG("ranking") FROM footballers WHERE "nationality" = 'saudi arabia' AND "years" = '2000–'

Question: Which nation had 14 goals?
SQL: SELECT "nationality" FROM footballers WHERE "goals" = 14

Question: What nationality is hamzah idris?
SQL: SELECT "nationality" FROM footballers WHERE "name" = 'hamzah idris'

Question: Who had fewer goals than 4 during the years of 1996–13?
SQL: SELECT MIN("goals") FROM footballers WHERE "ranking" < 4 AND "years" = '1996–13'