56,678
社区成员
发帖
与我相关
我的任务
分享
SELECT cust_name,
cust_state,
(SELECT COUNT(*)
FROM orders
WHERE oders.cust_id = customers.cust_id) AS orders
FROM customers
ORDER BY cust_name;
SELECT COUNT(*)
FROM orders,customers
WHERE oders.cust_id = customers.cust_id)