Select the name and price of all products with a price larger than or equal to $180, and sort first by price (in descending order), and then by name  (in ascending order).
CREATE TABLE products (name VARCHAR, price VARCHAR)
SELECT name, price FROM products WHERE price >= 180 ORDER BY price DESC, name
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE products (name VARCHAR, price VARCHAR) Question: Select the name and price of all products with a price larger than or equal to $180, and sort first by price (in descending order), and then by name  (in ascending order). [/INST] SELECT name, price FROM products WHERE price >= 180 ORDER BY price DESC, name </s>