Question

create table:
Account(cust-name,Acc_no, branch_name,balance)
Solve following query:Create above tables with at least 10 tuples
1 Find the average account balance
2 Find total balance available at pune branch
3 find total number of account in bank
4 find name of customer having minimum balance
5 find name of customer having maximum balance at pune branch
6 find total number of customer havaing balance >=50000
7 find total number of customer havaing balance 5000 to 100000 8 find total number of customer havaing balance null

Answer 1

Answer:

Druidic Roderick Godolphin old