面试题：MySQL NOT操作符在复杂条件下的数据排除应用

Question

已知有两个表，`orders`表包含`order_id`、`customer_id`、`order_date`和`total_amount`字段，`customers`表包含`customer_id`、`customer_name`、`city`字段。需要查询出居住城市不在`'New York'`且订单总额小于1000的所有订单信息，写出完整的SQL查询，要使用连接和NOT操作符。

Answer 1

SELECT o.order_id, o.customer_id, o.order_date, o.total_amount
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
WHERE c.city != 'New York' AND o.total_amount < 1000;