CREATE TABLE stadium (name VARCHAR(255), location VARCHAR(255), stadium_id VARCHAR(255)); CREATE TABLE concert (stadium_id VARCHAR(255), Year VARCHAR(255))
Find the name and location of the stadiums which some concerts happened in the years of both 2014 and 2015.
    
SQL: SELECT T2.name, T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.Year = 2014 INTERSECT SELECT T2.name, T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.Year = 2015