Table: gamecocks_soccer_stats
Columns: rank
player
goals
assists
points
years

Question: What years did the player play when he scored 78 points and 22 goals?
SQL: SELECT "years" FROM gamecocks_soccer_stats WHERE "points" = '78' AND "goals" = '22'

Question: How many goals did Joey Worthen have when he had 15 assists?
SQL: SELECT "goals" FROM gamecocks_soccer_stats WHERE "assists" = '15' AND "player" = 'joey worthen'

Question: How many goals were scored when 158 points were collected?
SQL: SELECT "goals" FROM gamecocks_soccer_stats WHERE "points" = '158'

Question: What years had players who scored 36 goals?
SQL: SELECT "years" FROM gamecocks_soccer_stats WHERE "goals" = '36'

Question: What was the rank of the player who had 13 assists?
SQL: SELECT "rank" FROM gamecocks_soccer_stats WHERE "assists" = '13'