You administer a Microsoft SQL Server 2008R2 database that hosts a customer relationship management (CRM) application.
The application supports the following two types of customers as shown in the exhibit. (Click the Exhibit button.)
•Business customers who have shipments sent to their office locations
•Residential customers who have shipments sent to their home address
You need to generate a list of residential customers who live in North America.
Which three Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)
Exhibit:
Build List and Reorder:
