Task: Text to Code
Input (English): Step 1: find the City of branch table.
Step 2: For each row in membership_register_branch table, find corresponding rows in member table and in branch table.
Step 3: find City of the results of step 2 whose Level greater than 100.
Step 4: show the rows that are in the results of step 1 but not in the results of step 3
Output (English): SELECT T1.City FROM branch AS T1 EXCEPT SELECT T1.City FROM member AS T2 JOIN branch AS T1 JOIN membership_register_branch AS T3 ON T2.Member_ID = T3.Member_ID AND T3.Branch_ID = T1.Branch_ID WHERE T2.Level > 100