Database: art_1
Question: How many paintings were created before 1900 in different locations?
SQL:
SELECT count(*) ,  LOCATION FROM paintings WHERE YEAR  <  1900 GROUP BY LOCATION