Database: art_1
Question: List the painting id, location and title of the medium oil paintings ordered by year.
SQL:
SELECT paintingID ,  title ,  LOCATION FROM paintings WHERE medium  =  "oil" ORDER BY YEAR