Table: nma_sports
Columns: rank
of_titles
school
city
sport
first
last

Question: What city is the School, Highland, in that ranks less than 8 and had its first title before 1980 and its last title later than 1960?
SQL: SELECT "city" FROM nma_sports WHERE "rank" < 8 AND "first" < 1980 AND "last" > 1960 AND "school" = 'highland'

Question: What city is the school that had less than 17 titles in boys basketball with the last title being after 2005?
SQL: SELECT "city" FROM nma_sports WHERE "of_titles" < 17 AND "last" > 2005 AND "sport" = 'boys basketball'

Question: What is the highest rank for the boys swimming team in Albuquerque?
SQL: SELECT MAX("rank") FROM nma_sports WHERE "sport" = 'boys swimming' AND "city" = 'albuquerque'

Question: What is the total rank number for Los Alamos' girls cross country?
SQL: SELECT COUNT("rank") FROM nma_sports WHERE "school" = 'los alamos' AND "sport" = 'girls cross country'