Show card number, name, and hometown for all members in a descending order of level.
CREATE TABLE member (card_number VARCHAR, name VARCHAR, hometown VARCHAR, LEVEL VARCHAR)
SELECT card_number, name, hometown FROM member ORDER BY LEVEL DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE member (card_number VARCHAR, name VARCHAR, hometown VARCHAR, LEVEL VARCHAR) Question: Show card number, name, and hometown for all members in a descending order of level. [/INST] SELECT card_number, name, hometown FROM member ORDER BY LEVEL DESC </s>