jagatrp Answered 1 Years ago through
Quizzes
SELECT
C.CustomerID,
C.CompanyName,
C.Country,
SUM(CASE WHEN C.Country='USA' THEN 1 ELSE 0 END) AS NumberOfOrders
FROM
dbo.Customers AS C
INNER JOIN
dbo.Orders AS OH
ON C.CustomerID = OH.CustomerID
GROUP BY
...