SELECT C.cname
FROM Customer C
WHERE NOT EXISTS (
SELECT B.bname
FROM Branch B
WHERE B.bcity='Karkal' AND B.bname NOT IN (
SELECT A.bname
FROM Account A, Depositor D
WHERE A.accno=D.accno and D.cname=C.cname
GROUP BY A.bname HAVING COUNT(*)>=2
)
);

SELECT C.cname
FROM Customer C
WHERE NOT EXISTS (
SELECT DISTINCT(B.bcity)
FROM Branch B
WHERE B.bcity NOT IN (
SELECT B1.bcity
FROM Account A, Depositor D, Branch B1
WHERE A.accno=D.accno AND A.bname=B1.bname AND D.cname=C.cname
));

SELECT C.cname
FROM Customer C
WHERE EXISTS (
SELECT COUNT(B.bname)
FROM Branch B, Account A, Depositor D
WHERE B.bcity='Mangalore' AND A.accno=D.accno AND A.bname=B.bname AND
D.cname=C.cname
GROUP BY B.bcity HAVING COUNT(*)>=2
);

Edit

Pub: 12 Jan 2022 03:58 UTC

Views: 209