Table: pele
Columns: name
goals
caps
first_cap
latest_cap

Question: When was the first cap associated with 74 caps?
SQL: SELECT "first_cap" FROM pele WHERE "caps" = 74

Question: How many goals are associated with over 97 caps and a Latest cap of april 24, 2013?
SQL: SELECT AVG("goals") FROM pele WHERE "latest_cap" = 'april 24, 2013' AND "caps" > 97

Question: When was the first cap associated with 39 caps and under 33 goals?
SQL: SELECT "first_cap" FROM pele WHERE "goals" < 33 AND "caps" = 39

Question: What is the highest number of goals associated with 39 caps?
SQL: SELECT MAX("goals") FROM pele WHERE "caps" = 39