STATISTICS IO: Example 2
In the previous exercise, you were asked you to provide a new regional manager daily updates on orders shipped to Western Europe capital cities. You initially created a query that contained two sub-queries. You decide to do a rewrite and use an INNER JOIN.
The STATISTICS IO command is turned on. You will need to turn it off after completing the query.
Este ejercicio forma parte del curso
Improving Query Performance in SQL Server
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
-- 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;