摘要: WITH customer_orders AS( SELECT customer_id,COUNT(*) AS order_count FROM orders GROUP BY customer_id ) SELECT customers.*,COALESCE(customer_orders.ord 阅读全文
posted @ 2023-03-08 22:18 vincent2023 阅读(1496) 评论(0) 推荐(0)