Database: art_1
Question: Find the locations that have paintings created before 1885 and after 1930?
SQL:
SELECT DISTINCT LOCATION FROM paintings WHERE YEAR  <  1885 INTERSECT SELECT DISTINCT LOCATION FROM paintings WHERE YEAR  >  1930