What is the highest Pick, when Nationality is "United States", when College is "New Mexico State", and when Round is greater than 6?
SELECT MAX Pick FROM table WHERE Nationality = united states AND College = new mexico state AND Round > 6