select C.custid,count (distinct O.orderid) AS 'ORDER_Num',SUM(qty) AS 'Product_Num'
from Sales.Customers AS C
JOIN Sales.Orders AS O
on C.custid = O.custid
JOIN Sales.OrderDetails AS D
on O.orderid = D.orderid
where C.country = 'USA'
group by C.custid
order by c.custid