Question

create a database "Bank"and then create a table customer in the database with the following fields (assign appropriate data types ).Insert records in the table as shown here.

●create a query to display names of customers from delhi
●create a query to display names of customers from chennai whose balance is more than rs2000
Acc.no. Name city balance (in rs )
1 george delhi 10,000
2 mary mumbai 50,000
3 Sam delhi 6000
4 sarah kolkata 7,500
5 robert chennai 8,000
6 peter delhi 19,000
7 rachel mumbai 20,000

​

Answer 1

Answer:

.................................................................

Explanation:

............ ..................