-- 查询指定城市的用户 SELECT * FROM users WHERE city IN ('北京', '上海', '深圳'); -- 查询年龄在20到30之间的用户 SELECT * FROM users WHERE age BETWEEN 20 AND 30; -- 查询特定状态的订单 SELECT * FROM orders WHERE status IN ('pending', '