Show all the cinema names and opening years in descending order of opening year.
CREATE TABLE cinema (name VARCHAR, openning_year VARCHAR)
SELECT name, openning_year FROM cinema ORDER BY openning_year DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE cinema (name VARCHAR, openning_year VARCHAR) Question: Show all the cinema names and opening years in descending order of opening year. [/INST] SELECT name, openning_year FROM cinema ORDER BY openning_year DESC </s>