-- 查询所有不重复的城市 SELECT DISTINCT city FROM users; -- 查询不重复的状态 SELECT DISTINCT status FROM orders; -- 统计不重复城市的数量 SELECT COUNT(DISTINCT city) AS city_count FROM users;