-- 按城市分组统计用户数 SELECT city, COUNT(*) AS user_count FROM users GROUP BY city; -- 按日期分组统计订单数 SELECT DATE(created_at) AS order_date, COUNT(*) AS order_count FROM orders GROUP BY DATE(created_at);