Solutions:
Check these solutions from our community and artificial intelligence:
The solution above is optimal because it uses a subquery to find the city of John Smith, and then uses that city to find all customers who live in that city.