Exercise

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.

Instructions 1/3

XP

1
2
3

Add the join operator.
Add the shipping destination city column in the filter condition.

Take Hint (-15 XP)