Show member names without any registered branch.
CREATE TABLE member (name VARCHAR, member_id VARCHAR); CREATE TABLE membership_register_branch (name VARCHAR, member_id VARCHAR)
SELECT name FROM member WHERE NOT member_id IN (SELECT member_id FROM membership_register_branch)
<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 membership_register_branch (name VARCHAR, member_id VARCHAR) Question: Show member names without any registered branch. [/INST] SELECT name FROM member WHERE NOT member_id IN (SELECT member_id FROM membership_register_branch) </s>