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?
a . select accountholderid
from accountholder
where cityid not in (select cityid from branchmaster)
b . select accountholderid
from accountholder
where cityid < > all (select cityid from branchmaster)
c . select accountholderid
from accountholder
where cityid < > some (select cityid from branchmaster)
d . select accountholderid
from accountholder
where cityid < > any (select cityid from branchmaster)