Database: shop_membership
Question: How many total pounds were purchased in the year 2018 at all London branches?
SQL:
SELECT sum(total_pounds) FROM purchase AS T1 JOIN branch AS T2 ON T1.branch_id  =  T2.branch_id WHERE T2.city  =  'London' AND T1.year  =  2018