Question

Find those branches having average balance greater than 800.dbms

Answer 1

select branch-name, avg(balance) from <table name> group by branch-name having avg(balance) > 800.