Find The Number Of Depositors For Each Branch Use Distinct #551
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 the number of depositors for each branch (Use distinct).
group by branch_name;
Answer:
select count(Distinct customer_name),branch_name from account natural join depositorgroup by branch_name;
