List the names of members who did not participate in any round.
CREATE TABLE member (Name VARCHAR, Member_ID VARCHAR); CREATE TABLE round (Name VARCHAR, Member_ID VARCHAR)
SELECT Name FROM member WHERE NOT Member_ID IN (SELECT Member_ID FROM round)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE member (Name VARCHAR, Member_ID VARCHAR); CREATE TABLE round (Name VARCHAR, Member_ID VARCHAR) Question: List the names of members who did not participate in any round. [/INST] SELECT Name FROM member WHERE NOT Member_ID IN (SELECT Member_ID FROM round) </s>