IN Subqueries

The IN operator with a subquery checks if a value exists in a result set:

SELECT * FROM customers
WHERE id IN (SELECT customerId FROM orders);

This finds customers who have placed at least one order.

Your Task

Find all customers who have placed orders in October 2025 (orderDate between '2025-10-01' and '2025-10-31').

Return the customer name and city.