Table: soccer_players
Columns: rank
player
nation
games
goals
years

Question: What is the smallest number of goals for the player from 2008-present named tony beltran, ranked lower than 7?
SQL: SELECT MIN("goals") FROM soccer_players WHERE "years" = '2008-present' AND "player" = 'tony beltran' AND "rank" > 7

Question: What is the smallest number of goals for andy williams?
SQL: SELECT MIN("goals") FROM soccer_players WHERE "player" = 'andy williams'

Question: What is the highest number of goals for robbie findley ranked above 10?
SQL: SELECT MAX("goals") FROM soccer_players WHERE "player" = 'robbie findley' AND "rank" < 10