Find Those Branches Where The Average Accounts Balance Is More #552
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 those branches where the average accounts balance is more than Rs. 1200.
having avg(balance)>1200
Answer:
select branch_name from account group by branch_namehaving avg(balance)>1200
