You administer a Microsoft SQL Server database that supports a shopping application.

You need to retrieve a list of customers who live in territories

that do not have a sales person.

Which Transact- SQL query or queries should you use? (Each correct answer presents a complete solution. Choose all that apply.)

A. SELECT CustomerID FROM Customer

WHERE TerritoryID <> SOME(SELECT TerritoryID FROM Salesper

son)

B. SELECT CustomerID FROM Customer

WHERE TerritoryID <> ALL(SELECT TerritoryID FROM Salesperson)

C. SELECT CustomerID FROM Customer

WHERE TerritoryID <> ANY(SELECT TerritoryID FROM Salesperson)

D. SELECT CustomerID FROMCustomer

WHERE TerritoryID NOT I

N(SELECT TerritoryID FROM Salesperson)

Explanation: