Database: geo
Question: how many states border colorado and border new mexico
SQL:
SELECT COUNT ( border ) FROM border_info WHERE border IN ( SELECT border FROM border_info WHERE state_name  =  "new mexico" ) AND state_name  =  "colorado";