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: