Task: Text to Code
Input (English): Step 1: find the City of branch table.
Step 2: For each row in branch table, find the corresponding rows in purchase table.
Step 3: find City of the results of step 2 whose Total_pounds 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 branch AS T1 JOIN purchase AS T2 ON T1.Branch_ID = T2.Branch_ID WHERE T2.Total_pounds > 100