Database: art_1
Question: Order all of the oil paintings by date of creation and list their ids, locations, and titles.
SQL:
SELECT paintingID ,  title ,  LOCATION FROM paintings WHERE medium  =  "oil" ORDER BY YEAR