Question

You administer a Microsoft SQL Server database that supports a banking transaction management application. You need to retrieve a
list of account holders who live in cities that do not have a branch location. Which Transact-SQL query or queries should you use?
SELECT AccountHolderID FROM AccountHolder WHERE CityID NOT IN (SELECT CityID FROM Branch Master)
SELECT AccountHolderID FROM AccountHolder WHERE CityID <> SOME (SELECT CityID FROM BranchMaster)
SELECT AccountHolder D FROM AccountHolder WHERE CityID <> ANY (SELECT CityID FROM Branch Master)
SELECT Account HolderID FROM Account Holder WHERE CityID = ALL (SELECT CityID FROM Branch Master)​

Answer 1

Answer:

qqqqqqqqqqqqqqqqqqqq

Answer 2

Answer:

.......

ur answer is in the above attachment