如何在SQL中正确地双连接

I'm trying to select all transactions with the billing_address city in 'New York', but with the shipping_address city not in 'New York'. The problem I'm struggling with is that when looking at the with the