Database: manufacturer
Question: List all manufacturer names and ids ordered by their opening year.
SQL:
SELECT name ,  manufacturer_id FROM manufacturer ORDER BY open_year