STATISTICS IO: ตัวอย่างที่ 2

-- Example 2
SELECT c.CustomerID,
       c.CompanyName,
       COUNT(o.CustomerID)
FROM Customers AS c
___ ___ Orders AS o -- Join operator
    ON c.CustomerID = o.CustomerID
WHERE o.___ IN -- Shipping destination column
     ('Berlin','Bern','Bruxelles','Helsinki',
	 'Lisboa','Madrid','Paris','London')
GROUP BY c.CustomerID,
         c.CompanyName;