Find All Customers Who Have At Most One Account At The #562
This subjective question is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Practical Questions Solved Past Paper No. 1.
Question 1: Find all customers who have at most one account at the Perryridge branch
having count(account_number)<=1;
Answer:
select customer_name from account natural join depositor where branch_name = ‘Perryridge’ group by customer_namehaving count(account_number)<=1;
