Database: art_1
Question: What are the numbers of paintings created before 1900 in different places?
SQL:
SELECT count(*) ,  LOCATION FROM paintings WHERE YEAR  <  1900 GROUP BY LOCATION